Problem of nested query

[MAGAR]

I have an error in my following query, it does not like the 2nd part. I have yet tested the "SELECT id FROM ..." all alone and it returns the ID property to erase:

DELETE FROM `crm_comment` WHERE id_comment in
(SELECT id FROM `crm_temps` WHERE crm_temps.salary='yann' and crm_temps.journey='2009-12-04' and crm_temps.id_project='58' )

MySQL gives the error message:

#1064 - 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 'SELECT id
FROM `crm_temps`
WHERE crm_temps.salary = 'yann'

What could be the problem of my above query?

[CitricAcid]

Why did you drop your table name in the from clause and not in the where clause? I see mysql is getting stuck over there.

[MAGAR]

Thank you for your comment, I tried this:

DELETE FROM `crm_comment` WHERE `id_comment` IN (
SELECT `id`
FROM `crm_temps`
WHERE `crm_temps.salary` = `yann` AND `crm_temps.journey` = `2009 - 12 - 04` AND `crm_temps.id_project` = `58`
)

I got this error message:

#1064 - 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 'SELECT `id`
FROM `crm_temps`
WHERE `crm_temps.salary` =

[CodGuru]

it is rather

    DELETE FROM `crm_comment` WHERE id_comment IN (
    SELECT id
    FROM `crm_temps` WHERE `crm_temps`.salary = 'yann' AND `crm_temps`.journey = '2009 - 12 - 04' AND `crm_temps`.id_project = 58
    )

[MAGAR]

With a copy/paste of your query, I got this:

#1064 - 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 'SELECT id
FROM `crm_temps`
WHERE `crm_temps`.salary = 'yan

But in between the 2 queries, they work well ...

Is it that it would be not recognized? I tried with 'match' but still an error.