The Insert Select command is new to me.
Would someone please tell me the error in the following:
mysql_query (\"INSERT INTO tmp_balances (bal_id,CustId,PAID,USED,Bal) SELECT ($CustId,sum($payment),sum($useage),sum($useage)-sum($payment)from transactions GROUP BY CustId)\")or die(mysql_error());
Insert Select Question
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users