Retrive The Data From Two Tables Using Where Condtion

SELECT employee_number,location_name
FROM tour_locations,tour_expeditions
WHERE tour_locations.location_code = tour_expeditions.location_code

SELECT e1.employee_name
FROM tour_guides e1,tour_guides e2
WHERE e1.hourly_rate=e2.hourly_rate AND
e2.employee_name='Siyabonge Nomvete'

To Retrive the two fields of data into a single Dropdownlist

sqlcommand cmd=new sqlcommand("select ename+eid as raju from Emp",con);
sqldatareader dr=cmd.excutereader()
{
while(dr.read())
{
ddl.items.add(dr[0]).tostring());
}
}