Inscrit le: 28 Sep 2017
|Posté le: Sam 11 Nov - 11:58 (2017) Sujet du message: PHP problem
I have a problem...
There are two tables: tblSales(productID, date, smth1, smth2) - primary key is poductID
tblPrices(productID, date, price) - primary key are productID and date.
I 'd like to obtain a recordset, which is the result of INNER JOIN this two tables according to criterium that mounth and year of date in both tables are the same.
How to do this using PHP?
I didn't find the right solution from the Internet.