Skip to content

Instantly share code, notes, and snippets.

@SushmaBaliza

SushmaBaliza/mysql-left-join.sql

Last active October 7, 2018 16:43
Show Gist options
  • Save SushmaBaliza/e6b1221f0cc01bcc3034df3d231fabf1 to your computer and use it in GitHub Desktop.
Save SushmaBaliza/e6b1221f0cc01bcc3034df3d231fabf1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-left-join.sql
SELECT a.Emp_id, a.Emp_name,a.Emp_Hire_date,b.Dept_name
FROM employees a
LEFT JOIN departments b
ON a.Dept_id=b.Dept_id
ORDER BY a.Emp_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment