My unknown SQL column on the left

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
+4
source share

Source: https://habr.com/ru/post/1629366/


All Articles