Delete from Table?

[stebut05]

Hi,

I hope you are all well. Thanks for taking a look at this thread. I have a table (table a), that is linked to a number of other tables (table b, c & d) though a value in column key. I need a query that will search table a and get all the values in column key, it will then delete all th rows in table b, c & d where the value in column key isnt present in table a.

Example:

Table A

Column Key
1. ABCD11111
2. ABCD11112
3. ABCD11113

Table B, C & D
Column Key
1. ABCD11111
2. SSSSSSSS1
3. ABCD11112
4. TTTTTTTTT1
5. ABCD11113

Based on the example i need to delete from table a, b & c where key != value 2 and 4.

I hope this makes sense. I have tried, but it keeps deleting all values except the last one in table a. Thanks in advance for any help, advice, etc.

Kind Regards,

Steven

[bpat1434]

DELETE FROM `b`.*, `c`.*, `d`.* 
WHERE `column_key` NOT IN(
    SELECT `column_key`
    FROM `a`
    ORDER BY `column_key`
)

Just replace b., c., d.* with whatever table-names you need to use.