RE: JOIN ON not supported in Access?

Hi John, The Access documentation states that Access does support left join (left outer join). You use this line here: FROM uprr_related_drawings rel, uprr_drawings dwg LEFT JOIN uprr_dateloc loc ON dwg.drawing_ID = loc.drawing_ID Try: FROM uprr_related_drawings AS rel

RE: JOIN ON not supported in Access?

> Subject: JOIN ON not supported in Access? I think that you have to explicitly use INNER JOIN in Access. In SQL Server 7, you can just use JOIN for inner joins. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5

JOIN ON not supported in Access?

Hi all I wrote this query: SELECT dwg.drawing_ID, dwg.drawing_number, dwg.title_uprr, dwg.title_secondary, rel.related_type FROM uprr_related_drawings rel, uprr_drawings dwg LEFT JOIN uprr_dateloc loc ON dwg.drawing_ID = loc.drawing_ID WHERE re