vendredi 31 juillet 2015

Group select data from table with Same lenght

my price table is like this:

enter image description here

i want to get query from price of two city in the same date from one product for comparing price. but in some time may be a city have more price on specific date, and the query of two city is not same length for comparing.

enter image description here

How to restrict two city price to just have get price if that product in two city is exists in specific time? like This:

enter image description here

Aucun commentaire:

Enregistrer un commentaire