multiply values from two tables

[chris89]

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

 

[Brianwarnock]

You need to read about Joins in help, understanding them is essential.

Brian

 

[chris89]

You need to read about Joins in help, understanding them is essential.

Brian

thank you for your reply I will try inner join