Well, the seamless window was blank. My query is "Select * From casonos, CAXXXXZB Where casonos.ZIPleft=CAXXXXZB.KEY"
I verified the syntax. What else might be causing problems? Thanks for the tools info, I've never really looked there before. Chris A. -----Original Message----- From: Woody Woodruff [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 3:37 PM To: Chris Alexander; 'Roberts, Michael'; 'mapinfo' Subject: RE: MI-L How to identify base tables Are they "seamless" tables - those are a collection of "base" tables treated as a single table for display and in layer control. To see, go to tools, Seamless Table manager and hit turn seamless tables off. If they are seamless, the names will show up in that list, if none are open, the list is blank. Seamless table manager is a stock MBX, so if its not in your tool menu, go to Tool manager, and turn it on. queries of these collections must take place at the base table level, not on the seamless table. If this is not the case, what is the WHERE clause you are trying, sometimes problems here throw up this error message. William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Chris Alexander [mailto:[EMAIL PROTECTED] Sent: January 08, 2004 14:40 To: 'Roberts, Michael'; 'mapinfo' Subject: RE: MI-L How to identify base tables As far as I know, I opened the tables in their original form. I haven't done any querying prior to my join. Are there some other clues I should look for? Chris A. -----Original Message----- From: Roberts, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 11:35 AM To: Chris Alexander Subject: RE: MI-L How to identify base tables Are you working with a sub set of the original data (i.e. a query) that is not saved as a tab file? That will give you an error sometimes. -----Original Message----- From: Chris Alexander [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 2:30 PM To: '[EMAIL PROTECTED]' Subject: MI-L How to identify base tables Hello, I'm trying to join CAXXXXZB (California Zip Boundaries) to CASONOS (streets in Sonoma County), but I get the "You can only perform dynamic joins on base tables" message. Both of these tables came with MapInfo. How can they *not* be base tables? Thanks! Chris K Alexander Marketing Data Analyst Advanced TelCom Group 19 Old Courthouse Square, Santa Rosa, CA 95404 Phone: 707-284-5395 Fax: 707-284-4259 [EMAIL PROTECTED] www.callatg.com <http://www.callatg.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: 9810 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9813
