Fetch Records From 2 Tables Conditionally

See more:

SQL-Server

hi

I Have 3 Tables:

User_Table: Friend_Table: Post_Table:

RankId Name ImagePath Id FriendId MyId Id PostId RankId PostMessage

We Have Only One ParaMeter SessionId(RankId) Which Is in Post_Table And UserTable Named As RankId

In Friend Table I Have Stored FriendId On Postion FriendId Or MyId Depends On Sending And Recieving Requests

now the qusetion is this:i want to show Name,ImagePath FROM UserTable And PostMessage FROM Post_Table if me or my friend post any message

ByChecking Either He/she is added with me in Friend_Table .


Give Me Any Other Ideas If U Have.

Please Help me

thanks in advance