problems with sql delete join

[snookie147]

Hello,
I want to use a delete sql with a join command in it, but I can't get it working...need some help on this one. What is wrong with the sql statement below? (I get an Microsoft JET Database Engine (0x80004005) error telling me that I have to indicate the table which I want to delete from).

Here is the wrong sql:

sql ="delete from orders left join products on orders.product_id = products.id where products.type_id="&var_type_id

 

[snookie147]

hi,
I just found the solution and I want to share it with you. The sql that works is:

sql ="delete orders.* from orders left join products on orders.product_id = products.id where products.type_id="&var_type_id