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

Yes it does, and it contains the same value in that field for each row that applies to that record. I am only wanting the row once. The field is the first field in the row, so I just 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'

and that seems to create the correct rows in the cursor. I'm just not use to using GROUP BY 1 to get rid of duplicates like this.

> Maybe you could limit the select from the People table?
>
I don't know quite what you meant by this.

Thanks,
Mel Cummings