Skip to content

Instantly share code, notes, and snippets.

@MITchongieball

MITchongieball/Syntax FULL JOIN

Created February 7, 2017 00:06
Show Gist options
  • Save MITchongieball/9d412b78e8d58911e67b11eeea5e7057 to your computer and use it in GitHub Desktop.
Save MITchongieball/9d412b78e8d58911e67b11eeea5e7057 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Syntax FULL JOIN
SELECT nama_tabel.nama_kolom,....
FROM tabel1
LEFT JOIN tabel2
ON tabel1.nama_kolom = tabel2.nama_kolom
UNION
SELECT nama_tabel.nama_kolom
FROM tabel1
RIGHT JOIN tabel2
ON tabel1.nama_kolom = tabel2.nama_kolom;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment