We help IT Professionals succeed at work.

Delete from a table a string of specific values

mtrussell
mtrussell asked
on
55 Views
Last Modified: 2017-06-30
I know I am close on this but how do I delete values from a table (where the key identifier is in a linked table)?

This is what I have but I get I am missing something...

DELETE *
FROM Tbl_ClientFlightControl
WHERE Location IN (SELECT Location FROM tbl_regions WHERE Region Like "Asia Only" Or "EMEA Only" Or "EMEA and Asia" Or "N/A");
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2010
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2010
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Thanks!