bartubozkurt/right_join.sql

Created June 11, 2021 19:47

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/b82ca8657cb9acbfa5dc43760a261137.js"></script>
Save bartubozkurt/b82ca8657cb9acbfa5dc43760a261137 to your computer and use it in GitHub Desktop.

Download ZIP

It is used to merge all rows from the second selected table and the matching rows from the first selected table. Returns null if there is a value in the second table that does not match the first table

Raw

right_join.sql

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

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