SQLize Online / PHPize Online  /  SQLtest Online

create table Dates(idate date); insert into dates select '1/1/2008'; insert into dates select '1/2/2008'; create table parts(partid int); insert into parts select 1; insert into parts select 2; create table orders1(partid int,idate date); insert into orders1 select 1,'1/1/2008'; insert into orders1 select 1,'1/2/2008'; insert into orders1 select 2,'1/1/2008'; select * from dates; select * from orders1; select * from parts; SELECT p.partid,d.idate, FROM parts p cross join dates d left join orders1 o ON d.idate = o.idate and p.partid = o.partid