Joined delete where records may or may not exist

2006-01-05 Thread Scott Haneda
Hello, mysql 4.0.18-standard-log (yeah, I know, I need to update, the date format changes are a nightmare :-)) I have two tables, cart, and products, I need to do this style delete: First, I need to join the two tables on the cart.product_id = products.id and delete those records where

Re: Joined delete where records may or may not exist

2006-01-05 Thread Dusan Pavlica
@lists.mysql.com Sent: Thursday, January 05, 2006 9:53 AM Subject: Joined delete where records may or may not exist Hello, mysql 4.0.18-standard-log (yeah, I know, I need to update, the date format changes are a nightmare :-)) I have two tables, cart, and products, I need to do this style delete: First, I