delete records form a mysql table

are you sure this works?  delete table1 from table2 where table1.field=table2.field it looks invalid to me.

Perhaps you could paste in the actual sql being used?

also, what is the extra query supposed to do, is it still just deleting rows in table1?

delete b2x1 from borrarproc where b2x1.email=borrarproc.email

Just deleted 1333 see attached screenshot. And yes it is just deleting rows in table 1

in your later example, apply this:

delete b2x1.* from b2x1
inner join borrarproc
on b2x1.email=borrarproc.email

Select allOpen in new window

if you want to delete records from table b2x1 which matched condition with table: borrarproc

May be you need to write something like this

DELETE t1,t2,t3 FROM table1 as t1
JOIN table2 as t2 ON t2.ID = t1.ID
JOIN table3 as t3 ON t3.ID = t1.ID

Select allOpen in new window

Worked like a charm

Thx