go to post 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