Query not MySQL 4.0.x compatible?

[bcamp1973]

This worked for me on my local install (4.1+) but it's not working on my ISPs install of 4.0.x. Is this query just not compatible?  If that's the case how else can i write this to make ti work??

 

SELECT type, notes.type_id, notes.id, note 
FROM notes 
JOIN (SELECT MAX(id) AS max_note, type_id FROM notes WHERE project_id=1 GROUP BY type_id) AS sub 
ON notes.id=sub.max_note 
LEFT JOIN types 
ON notes.type_id=types.id 
WHERE project_id=1

[fenway]

Nope... no subquery support; only way to do this is with a temporary table.