chucktrukk/has_many_through.sql

Created May 3, 2011 18:25

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

Download ZIP

From http://stackoverflow.com/questions/2640575/mysql-4-table-has-many-through-join

Raw

has_many_through.sql

	select a.*
	from Trucks t
	inner join Boxes b on t.id = b.truck_id
	inner join Apples a on b.id = a.box_id
	where t.owner_id = 34

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