Re: MI Objects Outside

1999-09-07 Thread Ewa Plachta
Hi, Sue Port is right. The other method is: Select all the objects which are within the relation1 and delete them - you will end up with objects which are outside. But remember to save the copy of the original table. Although this is not a very professional option it is much quicker than any

RE: MI Objects Outside

1999-09-06 Thread Sue Port
Hi Markus, You could do it via a subquery so the SQL would look something like this: Select * From relation1 where NOT obj Within Any (Select obj From relation2) However this SQL can get slow if you are dealing with large tables (I think it does the subquery for every record in relation1). A