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