DELETE FROM more than on table
Posted: Mon Nov 01, 2004 1:37 pm
Hello,
The following is a query string i use to delete a row from a table aswell as delete related rows from other tables
thing is it doesnt even delete the row from the main table.
Can i delete from more than one table in a single query?
Kendall
The following is a query string i use to delete a row from a table aswell as delete related rows from other tables
Code: Select all
DELETE products.*, product_options.*, price_options.* FROM products, product_options, price_options WHERE price_options.ProductID = products.ProductID AND product_options.ProductID = products.ProductID AND products.ProductID = '%s'Can i delete from more than one table in a single query?
Kendall