New post
Steven is an Avid Reader. No contributions for 2024.
Without a doubt, there will be something to
share on the Community in 2025!
User bio
404 bio not found
Member since May 9, 2017
Posts:
Steven has not published any posts yet.
Replies:
show all 4
Steven Potashnyk · Jul 18, 2021 
Select FACIL_DESC as "Hospital Type"
From SQLUser.CT_Hospital
JOIN SQLUser.PAC_FacilityType on (HOSP_FacilityType_DR=HOSP_FacilityType_DR)

output :

Private Hospital
Private Day Facility
Other
Public Hospital 
Public Day Facility

or the easier approach is using the arrow syntax

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_implicitjoins

Select HOSP_FacilityType_DR->FACIL_DESC
From SQLUser.CT_Hospital

Hope this helps

Certifications & Credly badges:
Steven has no Certifications & Credly badges yet.
Global Masters badges:
Steven has no Global Masters badges yet.
Followers:
Steven has no followers yet.
Following:
Steven has not followed anybody yet.