Here is my final select query. I am running several subqueries already to populate some temp tables. Is this enough to go on?
select
max(Comp.external_ID) external_ID
,max(Comp.member_name) member_name
,calls.date_called
,calls.hung_up
,calls.Appt_Sched
,calls.Refused
,calls.for_lang
,calls.Prior_Exam
,calls.Sched_Appt
,calls.Termed
,calls.No_Answer
,calls.No_Phone
,calls.Schedule
,calls.Wrong_Number
,calls.LTC
from
#compliance comp
left outer join #calls calls on Comp.external_ID = calls.amysisnbr
group by
Comp.external_ID
,Comp.member_name
,comp.Plan_PrimaryIdentifier
,Comp.plan_Secondaryidentifier
,comp.Compliance_Indicator
,Comp.service_date
,Comp.claim_number
,calls.Dob
,calls.Plan_Code
,calls.Date_Called
,calls.hung_up
,calls.Appt_Sched
,calls.Refused
,calls.for_lang
,calls.Prior_Exam
,calls.Sched_Appt
,calls.Termed
,calls.No_Answer
,calls.No_Phone
,calls.Schedule
,calls.Wrong_Number
,calls.LTC
order by
comp.member_name