Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting Items In Table A based on items in table B
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00676785
Message ID:
00676792
Views:
10
>I am looking for the best way to delete items in table A based on items in Table B. I have been using the seek and find then delete method if you know what I mean. I know there is a better way using an SQL statement of some kind. Thanks for your help.

Try
DELETE FROM table_a ;
  WHERE keyfield IN ( SELECT keyfield FROM table_b)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform