SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Help needed - mysql query
Threaded View
-
Dec 19, 2009, 17:18 #1
- Join Date
- Dec 2009
- Posts
- 3
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Help needed - mysql query
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
Bookmarks