outer joins on multiple tables

  • Thread starter Thread starter fred
  • Start date Start date
F

fred

does anyone know the syntax for doing outer joins on more
than one table ?
I want to select all USR_USERS records along with the
corresponding underlying Advertisers and Publishers
records (if any), thus:

SELECT USR.USR_KEY
FROM USR_USERS AS USR
LEFT OUTER JOIN ADV_ADVERTISERS AS ADV ON
(USR.USR_KEY=ADV.ADV_USR_KEY)
LEFT OUTER JOIN PUB_PUBLISHERS AS PUB ON
(USR.USR_KEY=PUB.PUB_USR_KEY)

But this shows a syntax error when trying to run it.
 
Try LEFT JOIN vice LEFT OUTER JOIN. ALSO Access demands that you use
parentheses to specify the order of the joins. I would try the UNTESTED SQL below

SELECT USR.USR_KEY
FROM (USR_USERS AS USR LEFT JOIN ADV_ADVERTISERS AS ADV
ON USR.USR_KEY=ADV.ADV_USR_KEY)
LEFT JOIN PUB_PUBLISHERS AS PUB ON
USR.USR_KEY=PUB.PUB_USR_KEY
 
Back
Top