sigma23/sql_join_on_values_and_null.sql

Created October 22, 2018 21:26

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sigma23/0f5e2b133255b0fe2d87cacebbb202d2.js"></script>
Save sigma23/0f5e2b133255b0fe2d87cacebbb202d2 to your computer and use it in GitHub Desktop.

Download ZIP

To do a join in sql and also keep null values

Raw

sql_join_on_values_and_null.sql

	select B., A.
	from B
	left outer join A ON
	(A.[id1] = B.[id1] or (coalesce(A.[id1],B.[id1]) is null))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment