sql query

Question

table1: userdetails

company _Name	department_ID	user_ID	user_Name
1	1	10111	raja

table2: departments

department_ID	department_Name	Company_Name
1	HR	1

 

 

 

here i want a query  for  retrieve department name from Table2:departments    by using table1: company_Name and department_ID   with the userid and username 

 

 i want result like these here All numbered coloumns are bigint datatypes

 

user_Name	user_ID	DepartmentName
Raja	10111	HR

 

 

 thanks for advance