I am stuck in the left junction and cannot see what I am doing wrong. I get the unknown column "_JobTable.JobTypeID" in the "on" section, but I cannot process it.
Can someone point out that I'm just losing sight and going to hit myself in the head for later?
SELECT
_RefTable.RefID,
_JobTable.JobID,
_Client.ClientName,
_Type.Description,
_Job.JobDetails,
_RefTable.SiteID,
_RefTable.SiteName,
_RefTable.SiteAddressState,
_RefTable.SiteAddressSuburb
from _RefTable
LEFT JOIN(
SELECT
_JobTable.JobID,
_JobTable.JobTypeID,
_JobTypeTable.Description
FROM _JobTable, _JobTypeTable WHERE _JobTable.JobTypeID = _JobTypeTable.JobTypeID
) as _Type on _JobTable.JobTypeID = _Type.JobTypeID
LEFT JOIN(
SELECT
_RefTable.RefID,
_ClientTable.ClientName
FROM _RefTable, _ClientTable WHERE _RefTable.ClientID = _ClientTable.ClientID
) as _Client on _RefTable.RefID = _Client.RefID
LEFT JOIN(
SELECT
_RefTable.RefID,
_JobTable.JobID,
_JobTable.JobDetails
FROM _RefTable, _JobTable WHERE _RefTable.RefID = _JobTable.RefID
) as _Job on _RefTable.RefID = _Job.RefID
source
share