Re: Join Statement with math operation

[stanley sioteco]

ok sir let me give you an example

name item amount kind
A Room Ch 9500 2
A Beer 50 6
B Room Ch 5200 2
A Deposit 9000 1

the query above will give me the following result

name Balance
A 550
B Null

i need this result sir

name Balance
A 550
B 5200

thanks!