I believe the problem is with base tables verses a named query. Try this SQL which operates on the 2 base tables, USA which contains the state objects and UsCuty_8k for the cities, or use any other city table you want.
Select * from Usa, Uscty_8k where Usa.State = "WY" AND Usa.obj Contains Uscty_8k.obj into WyomingCities Browse * From WyomingCities William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Tim.Nuteson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 12, 2002 10:56 AM To: [EMAIL PROTECTED] Subject: MI-L SQL statement not saved in workspace If I do these two selections in Mapinfo Pro: select * from States where stabbr = "WY" into WyomingState select * from Cities where obj within (select obj from WyomingState) into WyomingCities It works just fine. I end up with a table of WyomingCities I can map, browse, etc. When I save the workspace, however, only the first of the two select statements is saved. When I load the workspace, it comes up with no sign of the WyomingCities table. Is this normal, works-as-designed behavior? Can anyone explain this? I'm using Mapinfo Pro 6.5 Thanks- Tim Nuteson Target Corporation --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4043 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4141
