waldyrfelix/left outer join.sql

Created November 8, 2011 17:37

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

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

Download ZIP

Teste usando left outer join para a consulta

Raw

left outer join.sql

	select count(*) from categoria c
	left outer join produto p on c.Id = p.categoria_id
	where p.id is null

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