Untitled

SELECT 
    e.EMPID, 
    e.EMPNAME, 
    d.DEPTNAME, 
    s.BASIC
FROM 
    employee_info e
JOIN 
    dept_info d ON e.DEPTID = d.DEPTID
JOIN 
    salary_info s ON e.EMPLOYEE_CATEGORY = s.EMPLOYEE_CATEGORY
WHERE 
    d.DEPTNAME = 'HR';