Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Using Arrow with left join

Question
Nezla · Sep 23, 2021

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

#Ensemble
Product version: Ensemble 2014.1

Source URL:https://community.intersystems.com/post/using-arrow-left-join