Jump to content

LEFT JOIN ORDER ?


raindropz

Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/131817-left-join-order/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.