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]

Reply via email to