To perform a join you will need at least one of the joined columns indexed -
MapInfo knows this and will make sure that an index is created for the
second table in the query. The only bad thing MapInfo does not tell you
this. If you cannot write to the disk where the index is to be
created(permissions?) the Select would fail. I always make sure my joined
columns are indexed before the join.
Chuck Collins
[EMAIL PROTECTED]
Nucomm Data, Inc.
http://www.mnmaps.com
=====================
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Venkatesh K
Sent: Thursday, December 24, 1998 10:00 AM
To: [EMAIL PROTECTED]
Subject: MI Bug in Mapinfo SQL?
Hi,
I am facing a peculiar problem in Mapinfo SQL.
Consider this simple SQL statement
"Select table1.field1 from table1,table2 where
table1.field1=table2.field1 or table1.field1=table2.field2"
Trying to execute this statement gives an error
"No join specified between the tables or invalid where condition"
The statement appears perfectly allright to me.It executes without an
error in MS-Access. all the columns used in the SQL are character
fields.
I get the same error in both Ver4.5 and Ver5.0.
Thanks in advance
Venkatesh K
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
