[SOLVED] Table Join Syntax Problem

[kingnutter]

This looks right to me, but it isn't working.

 

I am trying to delete a row from table 'genrelinkcd' gl based on gl.moj_id and g.moj_genre from table 'genres'. genre_id is common to the two.

 

Please could somebody help me with my syntax if they have a moment.

 

Cheers,

KN

 

DELETE
FROM genrelinkcd gl
INNER JOIN genres g
ON g.genre_id = gl.genre_id
WHERE g.moj_genre = 'Alf' AND gl.moj_id = '211'

[kingnutter]

No worries. I've done it as a subquery:

 

DELETE FROM genrelinkcd 
WHERE moj_id = 211
AND genre_id = (SELECT genre_id FROM genres WHERE moj_genre='Alf')