I would like to show data from the subquery. I would like to show c.approved_by_description and other columns but in main part it will not allow the subquery columns:
Select a.Full_name, b.program_start_date, b.program_end_date from all_clients_view a
inner join program_enrollment_expanded_view b
on a.people_id = b.people_id
where a.discharge_dt is not null and b.program_name = 'CFTSS'
and a.people_id not in (select c.people_id from service_plan_goals_objectives_methods_view c where c.approved_by_description is not null) order by full_name