Click to See Complete Forum and Search --> : how to add and deduct


gampe0214
03-31-2007, 05:12 PM
how do i query?
if i have stock table, sale table, and return table ...i.e. if i want to add the item that is returned in rtn table to item in stock table and deduct item sold frm sale table .

linkstraffic
04-04-2007, 08:13 AM
separate the queries and you are done.