Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove trash from xlink table
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01243096
Message ID:
01243410
Views:
21
It's the same as
delete from M2m where Pk1 NOT IN (select Pk from Dok1) ;
   and Pk2 NOT IN (Select PK from Dok1)
>
>Here is another one
>
>delete from M2m where Pk1 # All (select Pk from Dok1) ;
>   and Pk2 # All (Select PK from Dok1)
>
>
>All the best.
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform