multiply values from two tables

chris89

Registered User.
Local time
Yesterday, 19:47
Joined
Nov 28, 2011
Messages
71
Hello
I have two tables that have the following fields:
tableProd:

tableProd.Prod, tableProd.valueProd, tableProd.dateProd

and tableRec:
tableRec.Prod, tableRec.Ing, tableRec.valueRec

I want to create a query where it finds where tableProd.Prod is equal with tableRec.Prod and then multiply tableProd.valueProd * tableRec.valueRec and GROUP BY tableRec.Ing

I don t know how to get the first part where the query looks for same values in the two tables and according to that it will multiply the two values.Could someone please help me on this?
Thank you in advance
 
You need to read about Joins in help, understanding them is essential.

Brian
 

Users who are viewing this thread

Back
Top Bottom