>>Here is the thread of interest GROUP BY 1 no longer works Thread #750415 Message #750415<
>
>Thank you Nadya.
>
>I see what I am dealing with now - and I will definately not be using Group By 1 in this situation.
>
>Your FAQ was also helpful.
>
>Mel Cummings

I'm thinking about this SQL:

select People.*, Address.* from People ;
inner join Address on People.PeopleID = Address.PeopleID ;
where Address.AddressID in ;
(select min(AddressID) as AddressID ;
from People inner join Address on ;
People.PeopleID = Address.PeopleID ;
group by People.PeopleID)