[EMAIL PROTECTED] wrote:
>
> 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 da
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
tab
