Как выполнить DELETE если есть условие для двух таблиц?

Question

[Sergey]

MYSQL 8.0

SELECT * 
  FROM osn86_jshopping_products_attr, osn86_jshopping_products_to_categories 
  WHERE osn86_jshopping_products_attr.product_id = osn86_jshopping_products_to_categories.product_id 
    AND osn86_jshopping_products_to_categories.category_id = 83

Как их удалить используя DELETE делит ругается что могу только в одной таблице удалить.
Пробовал вот так

DELETE FROM osn86_jshopping_products_attr 
  WHERE (SELECT * FROM osn86_jshopping_products_attr, osn86_jshopping_products_to_categories 
    WHERE osn86_jshopping_products_attr.product_id = osn86_jshopping_products_to_categories.product_id 
      AND osn86_jshopping_products_to_categories.category_id = 83 )

ошибка
#1241 - Операнд должен содержать 1 колонок

Comments

[Adamos]

конечно, пишет ошибку. У вас DELETE FROM table WHERE целая таблица вместо условия.

Answer 1

[Slava Rozhnev]

DELETE 
FROM osn86_jshopping_products_attr
WHERE product_id IN (
    SELECT product_id
    FROM osn86_jshopping_products_to_categories
    WHERE category_id = 83
);

Answer 2

[Danny Arty]

DELETE t1.*, t2.*
FROM osn86_jshopping_products_attr t1
INNER JOIN osn86_jshopping_products_to_categories t2
ON t1.product_id = t2.product_id
WHERE t2.category_id = 83