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 https://forums.phpfreaks.com/topic/192256-mysql-select-with-field-operation/ 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 https://forums.phpfreaks.com/topic/192256-mysql-select-with-field-operation/#findComment-1013153 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 https://forums.phpfreaks.com/topic/192256-mysql-select-with-field-operation/#findComment-1013158 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 https://forums.phpfreaks.com/topic/192256-mysql-select-with-field-operation/#findComment-1016910 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.