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:
Name Income Out Balance
Data1
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
Data2
question to ask
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:
Name Income Out
[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:
Name
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
On 26.02.2001 14:45:50 Dart 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
Data2970500
If i want to have the output:
Name