Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/FULL_OUTER_JOIN.sql

Created October 14, 2021 19:30
Show Gist options
  • Save vvgsrk/02434050448ac928a234d95821800f8d to your computer and use it in GitHub Desktop.
Save vvgsrk/02434050448ac928a234d95821800f8d to your computer and use it in GitHub Desktop.
Download ZIP
FULL OUTER JOIN
Raw
FULL_OUTER_JOIN.sql
SELECT e.last_name, e.department_id, d.department_name
FROM employees e FULL 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