|Subject||Re: outer join help|
> What I think you're looking for, is this:works perfectly. Thank you.
> select <fields> //probably more sensible than count(*)
> from clientinfo C
> left join PersonInfo PE
> on PE.Client_ID = C.Client_ID
> and PE.person_type_id = 0
> left join PaycheckInfo Pay
> on Pay.Person_ID = PE.Person_ID
> and Pay.sequence = 1
Appreciate all the help from everyone.