Skip to content

Instantly share code, notes, and snippets.

@SushmaBaliza

SushmaBaliza/mysql-right-join.sql

Created October 7, 2018 16:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SushmaBaliza/28bc34d08068623ceae132c921b676d4 to your computer and use it in GitHub Desktop.
Save SushmaBaliza/28bc34d08068623ceae132c921b676d4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-right-join.sql
SELECT a.Emp_id, a.Emp_name,a.Emp_Role,b.Dept_id,b.Dept_name,b.Location
FROM employees a
RIGHT 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