The following aint working

SELECT
Site._Switchboard
FROM Calls
LEFT OUTER JOIN Companies C ON Calls._fkCompanies = C._ID
LEFT OUTER JOIN Career J ON Calls._fkCareer = J._ID
LEFT OUTER JOIN Sites Site ON Calls._fkCompanies = Site._fkCompanies AND  J._fkSites = Site._SiteID

Its a very simplified version the last join isn't working correctly Site._Switchboard is blank.

The problem is the final "AND  J._fkSites = Site._SiteID"  if I replace that with "AND Site._SiteID = 0" it works. Naturally that's not a real option


Roy Lambert

I found my problem - I hadn't initialised the field so it was null not 0

Roy Lambert