Skip to content

Instantly share code, notes, and snippets.

@dhanish-jose

dhanish-jose/left_outer_join.sql

Created November 20, 2016 15:47
Show Gist options
  • Save dhanish-jose/f5ee9276ac791e89b33c2af68ce2bad9 to your computer and use it in GitHub Desktop.
Save dhanish-jose/f5ee9276ac791e89b33c2af68ce2bad9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
left_outer_join.sql
SELECT emp_name, dep_name
FROM emp
LEFT OUTER JOIN department
on dep_id_pk = dep_id_fk ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment