Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/LEFT_OUTER_JOIN.sql

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