commit b6762a17d18cc8e0288db8a0fccc5a44a9102d93 parent c6c4fcdb710367b2818e34f770d4a91a30cdfa16 Author: AndrewLockVI <andrewlaack1@gmail.com> Date: Sun, 2 Jul 2023 16:49:56 -0500 Completed replace employee id with unique identifier with mySQL Diffstat:
| A | replace-employee-id-with-the-unique-identifier/replace-employee-id.sql | | | 6 | ++++++ |
1 file changed, 6 insertions(+), 0 deletions(-)
diff --git a/replace-employee-id-with-the-unique-identifier/replace-employee-id.sql b/replace-employee-id-with-the-unique-identifier/replace-employee-id.sql @@ -0,0 +1,6 @@ +--Return the employees with their unique_id that +--is stored in another table. +SELECT EmployeeUNI.unique_id, Employees.name +FROM Employees +LEFT JOIN EmployeeUNI +ON Employees.id = EmployeeUNI.id