His balance is a running balance...
Joseph, you will have to keep the running balance in some thing
that you write to get the query.. you can't do a running sum
in SQL directly. You can only use the examples people provided
to get the net per line.
Joseph Bueno wrote:
>
> [EMAIL PROTECTED] a
[EMAIL PROTECTED] a écrit :
>
> Dear all,
> Sorry to ask question again, or maybe i am just a beginner.
>
> I wanna ask:
> If there are 2 records
> Name Income Out
> Data1 1000 700
> Data2970500
>
> If i want to have the output:
> Nam
Hi Jason!
Give this a try for the required table you want to produce below...
SELECT Name, Income, Out, (Income - Out) AS Balance
FROM ;
Sam.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 26, 2001 1:45 PM
Subject: MySQL question
select Name,Income,Out,(Income-Out) as Balance from tblname
On Mon, 26 Feb
2001 [EMAIL PROTECTED] wrote:
> Dear all,
> Sorry to ask question again, or maybe i am just a beginner.
>
> I wanna ask:
> If there are 2 records
> Name Income Out
> Data1 1000 700
>
