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