i am having trouble with the following statement:
delete from product inner join company_supplies on product.id = company_supplies.product_id where company_id = 1
it says i have an error near 'inner join'. can you not use inner join with delete in mysql? the select statement i use with the same syntax works fine...
thanks....
delete from product inner join company_supplies on product.id = company_supplies.product_id where company_id = 1
it says i have an error near 'inner join'. can you not use inner join with delete in mysql? the select statement i use with the same syntax works fine...
thanks....