Hi. I decided to tidy up some of my queries, but I came across something
that stumpt me:
mysql> SELECT
-> jobs.jobId,
-> jobs.active,
-> jobs.title,
-> jobs.listed,
-> industries.industry,
-> occupations.occupation,
-> agencies.agencyId,
-> agencies.agency,
-> contacts.contactId,
-> contacts.firstName,
-> contacts.lastName
-> FROM
-> jobs
-> LEFT JOIN industries ON jobs.industryId = industries.industryId
-> LEFT JOIN occupations ON jobs.occupationId =
occupations.occupationId
-> LEFT JOIN agencies ON jobs.agencyId = agencies.agencyId
-> LEFT JOIN contacts ON jobs.contactId = contacts.contactId;
Runs fine
mysql> SELECT
-> jobs.jobId,
-> jobs.active,
-> jobs.title,
-> jobs.listed,
-> industries.industry,
-> occupations.occupation,
-> agencies.agencyId,
-> agencies.agency,
-> contacts.contactId,
-> contacts.firstName,
-> contacts.lastName
-> FROM
-> jobs
-> LEFT JOIN industries USING (industryId)
-> LEFT JOIN occupations USING (occupationId)
-> LEFT JOIN agencies USING (agencyId)
-> LEFT JOIN contacts USING (contactId);
ERROR 1054: Unknown column 'industries.occupationId' in 'on clause'
Aren't these essentially the same statements? Or does "USING" not work the
way I think it does?
Thanks, Justin.