Don't use Update Column to join the two tables. Use SQL Select to specify a where clause that
select * From t1, t2 where (t1.state=t2.state) and (t1.city = t2.city) Make sure that the source column and the destination column have DIFFERENT NAMES. Then, update the query with Update Column Update query1 set dest_col=src_col Another possibility, if you have the city FIPS codes, is to create a column which concatenates the 2-digit state codes and the city codes into one 7-digit code. Do this in both tables. Then you can use Table->Update Column to transfer date between the two tables, joining based upon the new combined column. HTH Spencer -----Original Message----- From: Robert DeRubeis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 3:34 PM To: MapInfo-L Subject: MI-L Update Column Does anyone know of a way to update a column in one table based on TWO columns from another table? I have a U.S. city table I would like to update a column with, but I need the two tables to match between BOTH city and state columns (ideally a third column to include the county), not just the city column because that same city exists in multiple states. Any programs or ideas how this could be done? I am using MIPro v6.0. Thanks in advance, -Bob --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7388 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7389
