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
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