Deleting records

[Anon]

Anyone know how to delete records from TABLE1 using keys from TABLE2? The "Delete" command will only permit you to reference only (1) table.

Thanks.

[Anon]

I'm not sure, but something like this might work:

DELETE FROM table1 WHERE id = (SELECT id FROM table2 WHERE delete=1);

[Anon]

Thanks,

I'll give it a try.