带有左外连接和3个表的SQL

I would like to add an ADD at the end of my code. Please have a look on my code and thanks for your support:

我想在我的代码末尾添加一个ADD。请查看我的代码并感谢您的支持:

SELECT Area.org, 
   Supervisors.NomSup, 
   Supervisors.PrenomSup, 
   Employees.NomEmp, 
   Employees.PrenomEmp, 
   Employees.NoIdAlcanEmp, 
   Competencies.CodeCompetencies, 
   Competencies.CompetencyName, 
   LinkResultComp.AssNote, 
   LinkResultComp.AssDate
FROM ((((((
       Area INNER JOIN Supervisors ON Area.IdArea = Supervisors.IdArea
      )
      INNER JOIN Employees ON Supervisors.IdSupervisor = Employees.IdSupervisor
     )
     INNER JOIN LinkProfilesEmployees ON Employees.IdEmp = LinkProfilesEmployees.IdEmp
    )
    INNER JOIN Profiles ON Profiles.IdProfiles = LinkProfilesEmployees.IdProfiles
   )
   INNER JOIN LinkProfComp ON Profiles.IdProfiles = LinkProfComp.IdProfiles
  )
  INNER JOIN Competencies ON Competencies.IdCompetencies = LinkProfComp.IdCompetencies
 )
 LEFT OUTER JOIN LinkResultComp ON (Competencies.IdCompetencies = LinkResultComp.IdCompetencies AND ON Competencies.IdCompetencies = LinkResultComp.IdCompetencies)

WHERE Area.org LIKE "*20*" AND Competencies.CodeCompetencies LIKE "khse2010-05"
ORDER BY Supervisors.NomSup, Employees.NomEmp;

1 个解决方案

#1

Just remove the extra ON that you added

只需删除您添加的额外ON

So change this

所以改变这个

LEFT OUTER JOIN LinkResultComp 
ON (Competencies.IdCompetencies = LinkResultComp.IdCompetencies 
  AND ON Competencies.IdCompetencies = LinkResultComp.IdCompetencies)
------^^ This one

to this

LEFT OUTER JOIN LinkResultComp 
ON (Competencies.IdCompetencies = LinkResultComp.IdCompetencies 
  AND Competencies.IdCompetencies = LinkResultComp.IdCompetencies)

Of course I assume you meant different fields for the second condition

当然,我认为你的第二个条件意味着不同的领域

#1