nalaekaw/left_join

Created September 17, 2022 07:20

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

Download ZIP

Raw

	SELECT pp.*, p.name
	FROM product_photo pp
	left join product p
	ON p.id = pp.product_id;

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