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
INNER JOIN
uprr_drawings AS dwg
ON
uprr_drawings.drawing_ID = uprr_related_drawings.related_drawing_ID
LEFT JOIN
uprr_dateloc AS loc
ON
uprr_drawings.drawing_ID = uprr_dateloc.drawing_ID
This might help, I've had problems with aliases working inside the query
before.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
