I Want To acess Department Name In Dropdown From manage Doct

Question

Question in mvc.net 

1 .There are two table

A.Manage Doctors (Department_Id ) Fk

B.Manage Doctors Department Id Pk

Now I Want Access In Controller Name :

Controller Name:- ManageDoctors/Create

I Want To acess Department Name In Dropdown From manage Doctors

How I can achieve this ? ...

My Query Is Working

Here

Select Department_Name From ManageDoctorsDepartments where Id=+Id;