fetching data from three tables

I am having three tables

1. user(id,fname,lname)


2. picture(picid,pic_path,userid)



3. friends(friend_of,friends_id,status)

   
   
   

   want to fetch id,fname,lname,pic_path for all friends_id of friends_of=1

picture path may be null

---