Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/RIGHT_OUTER_JOIN.sql

Created October 14, 2021 19:27
Show Gist options
  • Save vvgsrk/589957bb22f832c830f28f1df0081fe2 to your computer and use it in GitHub Desktop.
Save vvgsrk/589957bb22f832c830f28f1df0081fe2 to your computer and use it in GitHub Desktop.
Download ZIP
RIGHT OUTER JOIN
Raw
RIGHT_OUTER_JOIN.sql
SELECT e.last_name, e.department_id, d.department_name
FROM employees e RIGHT OUTER JOIN departments d
ON (e.department_id = d.department_id);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment