query from two tables

Question

hi i want to get data like friendAddRequests that are shown on our home page when we sign in any social networking website like orkut. 

fields are 

table:profile

1.profile_Id

2.pimage

table:friends

1.friendid

2.myid

from friend table i want to get friendid like (select friendid,myid from friends where myid=profile.myid)

where profile.myid is profile field of web.config file

n this data i want to load in gridview 

bt after getting "friendid" from friends i want to get profile_image of friendid from "profile"  table where friendid(in profile table is profile_Id)..