Is there anything wrong with this statement? It gives syntax error: delete from table1 t1 left join table2 t2 on t1. Id=t2.id, where t2.id is empty

Question

Is there anything wrong with this statement? Syntax error occurred in mysql

delete
from table1 t1
left join table2 t2 on t1. Id=t2.id
where t2.id is null

Please give us your suggestions

Answer 1

When joining, you need to specify which table you want to delete from

delete t1
from table1 t1 
left join table2 t2 on t1.Id = t2.id 
where t2.id is null