Deleting two mysql table with php

[rcouser]

Hello i am trying to delete from two table with the following query

DELETE FROM product_items
JOIN cables_specification ON ( product_items.product_item_id = cables_specification.product_item_id )
WHERE product_items.product_item_id = 1

But I just get this error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM product_items JOIN cables_specification ON ( product_items.product' at line 1

Weird because i can use

SELECT *
FROM product_items
JOIN cables_specification ON ( product_items.product_item_id = cables_specification.product_item_id )
WHERE product_items.product_item_id = 1

[flyhoney]

You cannot do a join in a DELETE statement.  You will need to do 2 separate deletes.

 

DELETE FROM 
product_items
WHERE product_items.product_item_id = 1

DELETE FROM 
cables_specification
WHERE cables_specification.product_item_id = 1

[rcouser]

Thanks flyhoney got it sorted,

I think the ability to delete like that should be added at the next version of sql

Cheers