SELECT friendname FROM social_friend WHERE username = $_SESSION[user] AND friend_status='2'

            $query = "SELECT DISTINCT f.status_mesg,f.username,f.session_id,f.status,f.guest,f.in_room,u.email,a.username,a.friendname,a.friend_status
                   FROM frei_session AS f
                   JOIN LEFT members AS u ON f.session_id=u.Id
                   JOIN LEFT social_friend AS a ON u.username=a.username
                  WHERE f.time>" . $this->online_time2 . "
                   AND f.session_id!=" . $_SESSION[$this->uid . 'usr_ses_id'] . "
                   AND f.status!=2
                   AND f.status!=0
                   AND f.guest=0
                   AND f.username=a.username
                   AND a.friend_status=2";

Okay so friend integration, I have a table called social_friend It has 3 colums: username - friendname - friend_status A typical call looks something like: ```` SELECT friendname FROM social_friend WHERE username = $_SESSION[user] AND friend_status='2' ```` Now keeping in mind I have a JOIN statement already going on for the avatars, it seems 2 JOIN's are needed on the get_buddies function. I am obviously not very good at this because my attempts, fail: Heres what I was trying: ```` $query = "SELECT DISTINCT f.status_mesg,f.username,f.session_id,f.status,f.guest,f.in_room,u.email,a.username,a.friendname,a.friend_status FROM frei_session AS f JOIN LEFT members AS u ON f.session_id=u.Id JOIN LEFT social_friend AS a ON u.username=a.username WHERE f.time>" . $this->online_time2 . " AND f.session_id!=" . $_SESSION[$this->uid . 'usr_ses_id'] . " AND f.status!=2 AND f.status!=0 AND f.guest=0 AND f.username=a.username AND a.friend_status=2"; ```` This isn't working. What am I doing wrong here?

Scratch that, LEFT JOIN not JOIN LEFT. Its working now.