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 970 500
>
> If i want to have the output:
> Name Income Out Balance
> Data1 1000 700 300
> Data2 970 500 770
>
> How to do that?
> Thx!!!!!!!!
>
> Yours sincerely,
> Jason Chan
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php