SELECT * FROM table1 LEFT JOIN table2 ON table1.id1 ... Browse other questions tagged sql ms-access join ms-access-2007 left-join or ask ...
stackoverflow.com