create join query on the same table

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
00
1 0 3 87
Log in or sign up to continue
Source URL: https://community.intersystems.com/post/create-join-query-same-table