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

Home > create join query on the same table

Question
Ahmad Bukhtiar · Nov 29, 2020

create join query on the same table

Hi 

I have a table where i want to create join query like

(select * from patients where facility=abc) qry1

left join (select * from patients where facility=xyz) qry2 on qry1.patientid = qry2.patientid

#SQL #Other
Product version: IRIS 2020.1

Source URL:https://community.intersystems.com/post/create-join-query-same-table