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
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.
Thanks Julian