raindropz Posted November 7, 2008 Share Posted November 7, 2008 I have 2 tables, i need to left join them table1: id categ table2: id_table1 id_post title I need to left join table1 with the LAST id_post from table2, GROUPED by id_table1, is there anyway to do that? I mean, i need to do something like an ORDER BY in the left join table2, but i dont know how to do it In simple word, I need to do a SELECT and get all unique categs: categ | id_post (last id_post from that id_categ) how could I do it? Quote Link to comment Share on other sites More sharing options...
fenway Posted November 8, 2008 Share Posted November 8, 2008 What does this have to do with a left join? 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.