Problem with Query

[suganya]

I have the 2 sql tables

DoctorMaster

DRID nvarchar(50)
FirstName nvarchar(100)
LastName nvarchar(100)
Gender bit
Address1 nvarchar(255)
Address2 nvarchar(255)
City nvarchar(100)
Country nvarchar(100)
SpecialityId nvarchar(100)

Speciality

SPIDnvarchar(12)
Speciality vnarchar(50)


I have 2 dropdownlist boxes & 1 textbox in my webpage. Based on the dropdownlist boxes & textbox I have to select the Name, Speciality & Suffix from the DB.


the query I have given is

"select dm.FirstName||dm.LastName "Name",sp.Speciality,dm.Suffix from DoctorMaster dm,Speciality sp where sp.SPID=dm.SpecialityID and dm.Country='" + ddlCountry.SelectedItem.Text.ToString() + "' or sp.Speciality='" + ddlDisease.SelectedItem.Text.ToString() + "' or dm.FirstName||dm.LastName "Name" like '" + txtName.Text + "%'";

can anybody give me the right query

[debasisdas]

what you want to select from the tables ?