| 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
Wim SturkenboomPosted Dec 9, 2014, 12:29 AM
select user_Name, user_ID, Department_Name
from userdetails
join departments on departments.department_ID=userdetails.department_ID
Joginder BangerPosted Dec 9, 2014, 12:30 AM
Note:- must be join both table behalf no Company_name
select u.UserName,u.Userid,d.Departmentname from Userdetails u
inner join departments d on u.company_name=d.Company_Name