Subject Re: outer join help
Author Ed Dressel
> 2. I made a point of telling you to qualify everything.
> You didn't.

mayebe I don't understand what 'qualify' means--I understood it to
mean that I explicity state which table each field comes from. Here's
my SQL:

> select Count(*)
> from clientinfo C
> left join PersonInfo PE
> on C.Client_ID = PE.Client_ID
> full join PaycheckInfo Pay on PE.Person_ID = Pay.Person_ID
> where PE.person_type_id = 0
> and Pay.sequence = 1

how would it look if everything was qualified? or what isn't qualified?


Ed Dressel