I am running 3.23 and am new to mysql I would like to do something like this:
delete t1 from t1, t2 where t1.col = t2.col and ... basically deleting every row in t1 that has a matching row in t2. 4.x has mechanisms to join 2 or more tables in update and delete statements, 3.x does not. Without upgrading, what are my options? Would these confusing left/right join clauses work with update/delete. If so, could I please get a litlle syntax example. Thanks for the help folks. Matthew Alan Phillips --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
