Delete from multiple tables in one query prt 2
Posted: Tue Aug 30, 2005 1:09 pm
Hey,
this is a continuation question from a posting i was reading in viewtopic.php?t=23774&highlight=delete+multiple
Now i have used with much success but this is for delete relating information among the tables
but at the moment i am trying to apply this to tables that MAY NOT have related information. To put it more in sentance term.
What would be a solutions of DELETE multiple tables that may or may not have related data?
Kendall[/url]
this is a continuation question from a posting i was reading in viewtopic.php?t=23774&highlight=delete+multiple
Now i have used
Code: Select all
DELETE FROM products, price_options, product_options USING products, price_options, product_options WHERE product_options.ProductID = products.ProductID AND price_options.ProductID = products.ProductID AND products.ProductID = 'test'but at the moment i am trying to apply this to tables that MAY NOT have related information. To put it more in sentance term.
I have been experimenting with the LEFT JOIN syntax of it but im sooo not getting the whole concept of LEFT JOIN when SELECT far less for using it with DELETE but how does the LEFT JOIN work in terms of precedence with DELETE?Im trying to delete related data in tables that may or may not have matches.
What would be a solutions of DELETE multiple tables that may or may not have related data?
Kendall[/url]