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

Wim Sturkenboom · Answer

Read up on joins select user_Name user_ID Department_Name from userdetails join departments on departments.department_ID=userdetails.department_ID

Joginder Banger · Answer

Hi MathuKumar Note:- must be join both table behalf no Company_name select u.UserNameu.Useridd.Departmentname from Userdetails u inner join departments d on u.company_name=d.Company_Name