bartubozkurt/left_join.sql

Created June 11, 2021 19:44

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

Select an option

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

Download ZIP

It is used to combine all rows in the first selected table and matching rows in the second selected table. If the values in the first table do not match the values in the second table, it gets null.

Raw

left_join.sql

	SELECT city.name, country.name
	FROM city
	LEFT JOIN country
	ON city.country_id = country.id;

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