> What I think you're looking for, is this:
>
> 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
>

works perfectly. Thank you.

Appreciate all the help from everyone.

Ed Dressel