Snipplr http://snipplr.com/language/sql/tags/join Recent snippets posted on Snipplr.com en-us Sun, 19 May 2013 12:09:21 GMT (SQL) left join trick - konami99 http://snipplr.com/view/60292/left-join-trick/

]]> Fri, 28 Oct 2011 12:01:05 GMT http://snipplr.com/view/60292/left-join-trick/ (SQL) inner join - BrentS http://snipplr.com/view/58525/inner-join/

]]> Fri, 09 Sep 2011 00:46:58 GMT http://snipplr.com/view/58525/inner-join/ (SQL) SQL Update With Join - lostumbrellas http://snipplr.com/view/57864/sql-update-with-join/

]]> Tue, 16 Aug 2011 12:59:48 GMT http://snipplr.com/view/57864/sql-update-with-join/ (SQL) users with more than one of a gateway - lastobelus http://snipplr.com/view/51050/users-with-more-than-one-of-a-gateway/

]]> Thu, 24 Mar 2011 07:20:25 GMT http://snipplr.com/view/51050/users-with-more-than-one-of-a-gateway/ (SQL) INNER JOIN (Grabs all info that matches both tables) - staley412 http://snipplr.com/view/48790/inner-join-grabs-all-info-that-matches-both-tables/ (Grabs all info that matches both tables)

]]> Fri, 11 Feb 2011 03:30:05 GMT http://snipplr.com/view/48790/inner-join-grabs-all-info-that-matches-both-tables/ (SQL) Joining the same table on different columns - Scooter http://snipplr.com/view/9607/joining-the-same-table-on-different-columns/ I had a situation recently where I needed to join the same table on different columns. Most web sites don't give an example of this, so I thought it a good idea to post here. The example below only shows joining twice, but you can join as many times as necessary.

]]> Mon, 10 Nov 2008 14:13:26 GMT http://snipplr.com/view/9607/joining-the-same-table-on-different-columns/