Hello all... I apologize in advance if this is a really simple problem... but here goes... I've got two databases, one of swimming lesson registrants and one is map of provincial postal codes. I'm trying to do a sql query to add the field comm_name from the postal code database to my lesson database matching on postal code (the common link is the postal code). My problem is (for example) I have 93 registrations from a particular pool, but when I link it to the postal code file to add the comm_name field I end up with 126 records... because some postal codes have more than one record in the postal code file (e.g. Blaine Lake has 6 postal code records (points) on the same postal code). I'm dealing with a many-to-many relationship where both files could have the same postal code listed numerous times, but the comm_name field is always the same for each postal code in the postal code file. Is there a distinct condition or something I should be using? Any thoughts would be appreciated? Rob Gilhuly, Research Coordinator City of Saskatoon Community Services Department - Leisure Services Branch mailto:[EMAIL PROTECTED] http://www.city.saskatoon.sk.ca/departments/leisure/research ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
