I have two tables - Table1:
id name number
------------------
1 x1 123
2 x2 234
...and Table2:
tbl1id title rank
--------------------
1 t1 3
1 t2 2
2 t1 3
1 t3 1
Is there a way I can join them to return result as showing max title based on min rank for given user:
id name number max_title rank
----------------------------------
1 x1 123 't3' 1
2 x2 234 't1' 3
question updated!