insert into table_a (column_a, column_b) values ('row1a','row1b'); insert into table_b (column_c, column_d) values ('row2a','row2b');
delete from table_a where column_a in (select column_a from table_b); --the subquery is invalid, but the where clause is passed as true resulting in all records deleted