Dear listers,
does anybody know how I can reverse a selection in MI?
I have 2 tables and I want to select all datasets from the first table,
which are not contained in the second table.
There is a very slow way to do it:
Select * from table1 where col1 not in (select col1 from table2) into
Selection
I am looking for a faster way to do it. I thought about selecting the
matching datasets (which is a lot faster) and then reversing the selection.
Select * from table1, table2 where table1.col1 = table2.col1 into Selection
But I can't figger out how to reverse a selection.
Any help would be appreciated
Silke Keuerleber
PTV AG
Verkehrstelematik
Softwareentwicklung
Tel.: +49 7 21 96 51- 465
Fax: +49 7 21 96 51- 693
E-Mail: [EMAIL PROTECTED]
____________________________
PTV
Planung Transport Verkehr AG
Stumpfstrasse 1
76131 Karlsruhe
Germany
http://www.ptv.de
http://www.reiseplanung.de
http://www.varta-guide.de
http://www.cityguidefinder.de
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
