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