Guys, i am new to this and i really appreciate your help.

I have two tables 1) status 2) friends



please see the above DB image and heres my query

SELECT message,time FROM status WHERE uid in (SELECT uid2 FROM friend WHERE uid1=10)

above query returns all message of each friend, i just want only one most recent message. How can i modify this query to get it done??

and please i want it without using aliasing

Thanks a lot