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 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. 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 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. 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
Archived
This topic is now archived and is closed to further replies.