>You can run your first select, then select distinct from it. Otherwise you >have to group by People.PeopleID and each field except for ID should be >some aggregative function, like min, but the result may be incorrect in >such case...

The first field in the cursor row (peopleid) is the one I need to be unique, so I added the GROUP By 1 as in the following:

	SELECT People.*,  Postal.address1, Postal.address2, Postal.city, ;
			Postal.state, Postal.zip, Postal.country ;
			FROM  appdata!People ;
			INNER JOIN appdata!Postal ;
			ON  People.postalid = Postal.postalid ;
                        GROUP BY 1 ;
			INTO TABLE THISFORM.MyTableFolder+'MyTable'

This appears to give me the results I would expect.

You think this is the correct way to get rid of the duplicates in this situation?

Mel Cummings