>Can someone tell me what code I would add to this statement to achieve >that. Adding DISTINCT does not give the results I need.

If there can be more than one People record does that record contain a PeopleId field?

If so the DISTINCT property will use that ID field to keep both records.

Maybe you could limit the select from the People table?

--rab