how to get the single user post data from two table in asp.n

Question

how to get the single user post data from two table in asp.net using c# with sql query. dear sir i have a one problem regarding get the data from database of single user data from two tables using asp.net .. i have two tables that table2 is user post data and table2 contain images paths of table one post datai want whos post the data from two tables ..i mean if i post the data i want display only my posts where postby=eswar.. i hope you understand my problem ..(i got the data but another persons posted data also )by using below query ...please write a right query to get the perfect data.. THankyou my query is: SELECT n.newsid n.state n.district n.region n.views n.currentplace n.newstitle n.description n.poston n.postby (SELECT TOP 1 imagepath FROM tbl_userpost_newsimages ni WHERE nipostby='+lbl_upname.Text+' and n.newsid=ni.newsid) AS imagepath FROM tbl_userpost_news n Order By n.poston desc

eswar rao · Answer

sir  thank you for given response to me..i got details whos posted with images and also i get the details another persons posted data with out showing images ..i want to display only one person data..i hope you understand my problem.. Thank you..

Sourabh Somani · Answer

I am not able to understand you what actually you want to do? please explain it clearly.

Manas Mohapatra · Answer

You already wrote to get post details and images by who posted it. So where is the problem now.