9/1 每日一題(MYSQL 合併表格,如果id不存在也要以null 輸出並列出對應的name)

 

# Write your MySQL query statement below

SELECT E2.unique_id, E1.name

FROM Employees AS E1

left join EmployeeUNI AS E2

on E1.id = E2.id