MySQL question to ask

2001-02-26 Thread Dart
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

Re: MySQL question to ask

2001-02-26 Thread Peter Skipworth
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

Re: MySQL question to ask

2001-02-26 Thread Samuel
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

Re: MySQL question to ask

2001-02-26 Thread Joseph Bueno
[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

Re: MySQL question to ask

2001-02-26 Thread Steve Ruby
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

Antwort: MySQL question to ask

2001-02-26 Thread alexander . skwar
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