I think the question is not very clear. Do you want to delete from all the tables or you just want to delete from one of the tables? Does your MySQL version support sub-queries? (Is it Ver 4.1.x ?)
I saw some replies to your question, did they solve your problem? I am asking this because a DELETE command is one of the most risky operations on data. Thanks Emery ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 17:25 Subject: deleting rows which table1.row=table2.row > how to delete rows which table1.field=table2.field > > thanks > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
