Make a copy of table1 then
select * from table1, table2 where table1.col1 = table1.col1 into
TMP
When the TMP browser appears, hit the delete key. The only
records that remain are the ones with no match in table2 (they
weren't selected.)
- Bill Thoen
Silke Keuerleber wrote:
>
> 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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
