SQL problem - Replace Employee ID With The Unique Identifier

1 min read 77 words

Problem

Query

SELECT unique_id, name
FROM EmployeeUNI
RIGHT JOIN Employees
ON EmployeeUNI.id = Employees.id

Editorial Solution

SELECT 
    * 
FROM
    Employees 
LEFT JOIN 
    EmployeeUNI 
ON 
    Employees.id = EmployeeUNI.id;