Sorry about that. I have the data ok but would like to know if it's possible to improve.
select ac.full_name, ai.*, pev.program_name
from all_clients_view ac left join
alt_id_view ai
on ac.people_id = ai.people_id left...
- This reply was modified 5 years, 5 months ago by pk400i.