Here is the code to delete records from a MySQL tabel with an outer join.

e.g. to delete the records from a products_to_categories table that have no product in the products table:

delete from pc
using products_to_categories as pc
left outer join products p on pc.products_id =p.products_id
where isnull(p.products_id)

This entry was posted on Monday, January 21st, 2008 at 22:37 and is filed under eBusiness, mysql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.