bcamp1973 Posted February 8, 2007 Share Posted February 8, 2007 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted February 8, 2007 Share Posted February 8, 2007 Nope... no subquery support; only way to do this is with a temporary table. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.