Thanks to all who came up with suggestions. The key word in the query is
ANY. Without it, the quesry doesn't work. Thanks Justusson.
Thanks,
Danny Heuman
> -----Original Message-----
> From: Justusson Christer [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 17, 2000 1:22 AM
> To: 'Dan Heuman'
> Cc: 'MI_List_csn'
> Subject: RE: MI How to Select NOT WITHIN
>
> Hello!
>
> The trick is where to place not. I think there is a techtip.
>
> Select * from Table1 where not obj within any (select obj from Table2)
>
> Best of regards
> Christer
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
