I want to write an efficient query that will delete all records from one table when they show up in another table (pending shipments --> shipped shipments). I can't do it with this:
mysql> DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno; because you can only refer to columns of one table in a delete query. Does anybody have an effiecnt way for me to do this with Perl DBI? Thanks! Rory --------------------------------------------------------------------- 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