jfernandes Posted February 16, 2010 Share Posted February 16, 2010 I Need to Create a Select with a Sum and also a result from the sum command Like this select sum(Credit) as credit, sum(debit) as Debit, (credit-debit) as balance from statement don't work can some please help me Quote Link to comment Share on other sites More sharing options...
fenway Posted February 16, 2010 Share Posted February 16, 2010 If you think that's sufficient information, you're mistaken. Quote Link to comment Share on other sites More sharing options...
jfernandes Posted February 16, 2010 Author Share Posted February 16, 2010 I'm sorry i tod was suffient information. I need to get a balance from table with credit and debit field. can you please let me know what else i can provide to you to help me Thanks Quote Link to comment Share on other sites More sharing options...
fenway Posted February 23, 2010 Share Posted February 23, 2010 I don't see what's not working -- see the link in my sig. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.