Problem with Query

[suganya]

I created 2 tables


DoctorRegistration2

Name varchar(50)
UserId1 varchar(50)
Password1 varchar(15)
Sex varchar(10)
Dob varchar(50)
EmailId varchar(50)

DoctorRegistration1

Country varchar(50)
State varchar(50)
City varchar(15)
Address varchar(200)
ContactNo varchar(50)
AreaOfSpecialization varchar(50)
Hospital varchar(50)
ConsultancyTiming varchar(50)
OnlineConsultancy varchar(15)
OnlineAppointment( varchar(10)




The thing is I have to select the Name from DoctorRegistration2 table based on AreaOfSpecialization & Country in DoctorRegistration1 table. For that I have given the query as

"select d.Name from DoctorRegistration2 d,DoctorRegistration1 d1 where d1.Country='" & Trim(ddlCountry.SelectedItem.Value()) & "'and d1.AreaOfSpecialization='" & Trim(DropDownList2.SelectedItem.Value()) & "'"

The problem is all names are getting displayed. How can I give the relation for both the tables & make it possible.

[debasisdas]

Is there ay relationship between these two tables ?

[ck9663]

Looks like you split the table to make it relational. You might need to defined a PK on both table which you can use to JOIN the two.

-- CK