Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Really? I didn't realize that was possible. I'll try it.
Thanks,
-Michelle
>Hi Michelle,
>
>I think you should be able to do this with the SQL delete command:
>
>DELETE FROM Trips WHERE trips.client_num NOT IN (SELECT client_num FROM clients)
>
>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement