Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting Select
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00179016
Message ID:
00179023
Views:
35
>>I got a feeling this isn't possible, but I thought I'd ask just in case. I want to do something like this:
>>
>>SELECT trips
>>DELETE ALL FOR trips.client_num NOT IN (SELECT client_num FROM clients)
>>
>>Basically, there's a lot of orphaned trips in the table and I want to clear them out. Is there any way to do that short of scanning through the trips table and looking up each client_num?
>>
>>Thanks,
>>
>>-Michelle
>
>Since correlated subqueries are not supported, you could set a relation from the child table into the parent, then delete for no match
>
>use parenttable order parentid
>select 0
>use trips
>set rela to parentkey into parenttable
>delete for eof( "parenttable" )

Ok, I'll try that. Thanks.

-Michelle
Previous
Reply
Map
View

Click here to load this message in the networking platform