>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
--
Raymond A. Biondi
RSL