Skip to content

Instantly share code, notes, and snippets.

@devheedoo

devheedoo/oracleJoin.sql

Created October 26, 2016 04:26
Show Gist options
  • Save devheedoo/9c64255e372c52c2f876091a8adb54fd to your computer and use it in GitHub Desktop.
Save devheedoo/9c64255e372c52c2f876091a8adb54fd to your computer and use it in GitHub Desktop.
Download ZIP
oracle join
Raw
oracleJoin.sql
/* COMMON */
SELECT *
FROM Person
JOIN Worker
ON Person.id = Worker.id;
/* Oracle (Same as above) */
SELECT *
FROM Person,
Worker
WHERE Person.id = Worker.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment