If you do:
Select * from table left join other_table on id=ext_id where ext_id is null
it works great. But if you want to convert that select to a delete you need to include ‘table.*‘:
Delete table.* left join other_table on id=ext_id where ext_id is null
It kind of makes sense, but MySql could be smart and get that we only want to delete from where there actually exists content.
