Dear Friends,
Please help for the select command, as i had tried many times and always can
not display the result as what i want.
I am looking for the solution on google but still can not found the right
answer to solve the problem.
I have 3 tables :
Table A
ProductID
Hengky Lie wrote
1. I want to select all productID from Table A where supplierID='XXX'.
2. Based on list from Step.1 : sum the initialstock from Table B
3. Based on list from Step 1 : Sum (in-out) from Table C where date
'BEGINNING DATE'
4. Based on list from Step 1 : Sum (in) and
Dear David,
Thanks for your reply.
Table A is product table contains ProductID, Name, Supplierid etc.
Table B is initial stock contains ProductID, Qty
Table C is the transaction table contains ProductID, date, in, out, remarks, etc
As i use trigger to write to a log file for any INSERT, UPDATE
Hengky Lie wrote
Dear David,
Thanks for your reply.
Table A is product table contains ProductID, Name, Supplierid etc.
Table B is initial stock contains ProductID, Qty
Table C is the transaction table contains ProductID, date, in, out,
remarks, etc
As i use trigger to write to a log