[RESOLVED] One to Many SQL statement (subquery)

[szlamany]

Never loop - always get the query right!

SQL is all about set-based logic!

Select tblIMUser.UserName From tblIMUser
Left Join tblBuddies on tblBuddies.BuddyId=tblIMUser.UserId
Where tblBuddies.UserId=4
Group by tblIMUser.UserName