hi...trying to circumvent the limitation of the DELETE statement only being able to use its own table...idea is to mark the records to be deleted via an UPDATE statement which allegedly accepts LEFT JOIN and then performing the DELETE statement.
Question is how to properly form a LEFT JOIN using UPDATE... I tried: UPDATE product_price LEFT JOIN temp SET product_price.product_price_vdate = 1 (del flag) ON product_price.product_id = temp.product_id WHERE temp.product_id IS NOT NULL as well as some other combos...to no avail! Anyone used this know the right syntax much appreciated!!! Luis ===== ---------------------------------------------------- Make it idiot-proof and someone will make a better idiot. __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php