Hello, I need to run the following query to populate the County field of my table based on what county polygon it is in:
Update MASTLOCN Set MASTLOCN.County=Counties.County where MASTLOCN.County = "" and MASTLOCN.Obj Within Counties.Obj Mapinfo is telling me "Expression does not evaluate to a column or table name" There is no info on Update queries in the help file or the web site except how to update an entire table or select query with a single value. Is Mapinfo syntax different or does it not support Update queries? One workaround is to do the select query and then Save Copy As... the query as DBF. Then I import the DBF into Access, attach the original DBF and run an update query there. A major pain! Thanks, Brad Mathews CTO, Cypress Technology Solutions, Inc. www.CypressSolutions.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2371
