Get sum fuction?[SOLVE]
Posted: Sun Jul 01, 2012 11:06 pm
Hi, all
how to get a sum of two field in different table.?
please help.
how to get a sum of two field in different table.?
please help.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/

Code: Select all
SELECT tbl_recieve.id,
tbl_recieve.uid,
tbl_recieve.cat_name,
tbl_recieve.product_name,
tbl_recieve.product_model,
tbl_recieve.rec_on,
tbl_recieve.return_on,
tbl_recieve.sold,
sum(tbl_recieve.balancs)as Balance FROM tbl_recieve INNER JOIN tbl_adm_rpl ON tbl_recieve.id = 'id' group by tbl_recieve.balancs order by Balance,
tbl_recieve.re_qty,
tbl_recieve.dt_nwo,
tbl_recieve.dt_response,
tbl_recieve.commnt,
tbl_recieve.dt_recve,
tbl_user.uid,
tbl_user.tbl_brnch_name,
tbl_user.f_name
FROM tbl_recieve INNER JOIN tbl_user ON tbl_recieve.uid = tbl_user.uid WHERE tbl_recieve.uid = '$_SESSION[SESS_MEMBER_ID]'";