Sir, I have these codes

CREATE CURSOR products (code c(4),products c(10))
INSERT INTO products values('1401','Apple')
INSERT INTO products values('1402','Mango')
INSERT INTO products values('1403','Banana')
INSERT INTO products values('1404','Dates')
INSERT INTO products values('1405','Peach')

CREATE CURSOR rates (date d(8),code c(4),products c(10),rate n(3))
INSERT INTO rates values({^2016/08/16},'1401','Apple',80)
INSERT INTO rates values({^2016/08/16},'1402','Mango',90)
INSERT INTO rates values({^2016/08/17},'1401','AppLE',100)
INSERT INTO rates values({^2016/08/17},'1405','Peach',110)

I want to create a report which will display rates from Rates.dbf again any given dates

Suppose I enter 16-08-16 then it must display all Products from Master.dbf and rates from Rates.dbf like this

code Products Rate
1401 Apple 80
1402 Mango 90
1403 Banana
1404 Dates
1405 Peach

I need sql solution only because I shall use the query in php+mysql.

I triedthis query but it displays only those products those are in rates table. But I want to display all products from Master.dbf+rates shown in image.

SELECT Rates.date,products.code, products.products,  Rates.rate;
  FROM  products ;
   left JOIN rates ;
   ON  products.code = Rates.code;
 WHERE  Rates.date = ( {^2016/08/16} )

Attachment is snapshot of tables.

Thanks