Skip to content

Instantly share code, notes, and snippets.

@ijan10

ijan10/left_outer_join.py

Created February 27, 2019 15:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ijan10/931a06314992d1bbcb945758aaa56153 to your computer and use it in GitHub Desktop.
Save ijan10/931a06314992d1bbcb945758aaa56153 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
left_outer_join.py
SELECT
l.col1,
l.col2… ,
r.col1,
r.col2…
FROM
left_tbl as l
LEFT OUTER JOIN ( SELECT
/*+ BROADCAST (right_tbl) */
*
from
( right_tbl )) as r ON
l.bin_id = r.jbin_id
AND l.l_col = r.r_col
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment