I know that MySQL 3.23.nnn did not support a delete subselect, just wondering what the best/most efficient way to do the following is:
delete from table_a where table_a.column_1 in ( select column_1 from table_b); Assuming that column_1 is the same data type and size in both table_a and table_b. Any help would be greatly appreciated. Regards, Tony
