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: >

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

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: > Nam

Re: MySQL question to ask

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

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