Question
Rochdi Badis · Sep 23

Using Arrow with left join

Hi Guys,

my understanding that Arrow can't be used in left or right joins as the example below, so is there an alternative ? 

SELECT Sample.Employee.Name, Sample.Company.Name AS CompName
FROM Sample.Employee LEFT OUTER JOIN Sample.Company
ON Sample.Employee.Company->Name = Sample.Company.Name

 

Thanks

Product version: Ensemble 2014.1
00
1 0 2 142
Log in or sign up to continue

Hey Rochdi.

The issue here is that you can't use the Arrow within the ON Clause and the alternative here would be to use ANSI Join syntax.

If it helps, the documentation (under Join Definitions) states that -> performs a left outer join? There's also a section further down for ON Clause if that is useful in any way.