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 products.online = 0 and here is the bit that I get stuck on, and where there is no matching products record. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]