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, 7 months ago by  pk400i.

So this should be fine? select a.*, b.full_name from alt_id_view a

left outer join all_clients_view b

on a.people_id = b.people_id

It's only bringing in the matched so it could be the system we...

Is it possible a Userid or password has been disabled?

in the report check your report parameters, make sure that they are there and as you want them. It sounds like the dates are embedded there, make them nulls.