SQLTeam.com | Weblogs | Forums

Help me read this SQL code

SELECT
MIN(PM.encounter_number) as 'fin'
,PD.full_name as 'name'
,PD.birth_date as 'DOB'
,MIN(PFA.start_dt_tm) as 'appt_date'
,PFA.location_name as 'location'
,PM.financial_class_display as 'fin_class'
,HCM.condition_display as 'condition'
,HCM.condition_type as 'type'
,case when HCM.condition_type = 'SATISFYED' then 1 else 0 end as 'numerator'
,c.prsnl_name as 'provider_name'

FROM SSS.PH_F_APPOINTMENT PFA

What do you think PM, PFA, PD are?

Welcome!

You might not be showing us the whole query but those are aliases as you see here the table ph_appointment is aliased as pfa.Same with PM is analoas for another table

1 Like

Thank you very much yosiasz!