just to be sure we are on same page... in Q1, what is subquery doing? (select max(c.price_start_date) from table2 As d INNER JOIN table1 as c ON d.Days = c.price_start_date where c.shop=a.shop and c.product_nb=a.product_nb) it is saying... for a specific shop and product_nb in the outer query, what was the latest price_start_date in the records in table1 for that specific shop

pat12@poczta.onet.pl wrote: There is two tables: 1. product_nb;price_start_date;shop;price 2. Days (dates from two months day par day) I try to get the info about the price for each shop and each product for each day from second table Here is my query: Select a.product_nb,b.days,a.price_start_date,a.shop, a.price from table1 as a,table2 as b where