Re: deleting rows which table1.row=table2.row

[Randy Chrismon]

[EMAIL PROTECTED] wrote:

how to delete rows which table1.field=table2.field

thanks
 

delete t1 from t1,t2 where t1.field=t2.field

at least, that's how I read the manual. Works for me.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]