Hi,

Can someone please help?

I have 2 tables in sql server.
Table ADS fields:
ad_poster 'username
ad_id
ad_title
ad_link
ad_description

Table USER
u_id 'username
u_password
u_phone
u_email

In vb.net I need to write all the fields into textboxes but I am not sure how to write the select statement.
This is what i tried but no textboxes are filled:
 Dim Ssql As String = "SELECT * FROM ADS, USERS WHERE AD_ID = @ad_id AND ADS.AD_POSTER = USERS.U_ID"

 CMD.Parameters.Add("@ad_id", ad_id)
the ad_id is received from a querystring.