Delete using a subquery shows #1064 error

Question

This query shows #1064 error.

DELETE FROM product_price AS pp
WHERE pp.PRODUCT_ID IN (
    SELECT PRODUCT_ID
    FROM (
        SELECT P.PRODUCT_ID
        FROM product p
        WHERE p.PRODUCT_NAME='watch') t
)

http://stackoverflow.com/questions/23515347/how-can-i-fix-mysql-error-1064 — Jozef Chocholacek, Jul 01 '16 at 08:30

score 0 · Answer 1 · answered Jul 01 '16 at 08:32

0

Use JOIN instead of subquery like this;)

DELETE pp FROM product_price AS pp
INNER JOIN product p ON pp.PRODUCT_ID = p.PRODUCT_ID AND p.PRODUCT_NAME='watch'

answered Jul 01 '16 at 08:32

Blank

12,308
1
14
32

score 0 · Answer 2 · answered Jul 01 '16 at 10:09

What is the 't' doing there? Try without that, like this:

  DELETE FROM product_price AS pp
  WHERE pp.PRODUCT_ID IN (
      SELECT PRODUCT_ID
      FROM (
          SELECT P.PRODUCT_ID
          FROM product p
          WHERE p.PRODUCT_NAME='watch')
  )

Delete using a subquery shows #1064 error

2 Answers2