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
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 an
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)
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
Produc
