Luis Cazares (8/9/2016)
It's not about one join being better than the other. It's about using the correct join for each query.Here's an explanation on how each join works.
http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
+1 on this. But remember that there are options other than joins to combine tables. There are also scalar subqueries, CROSS APPLY, OUTER APPLY, UNION, UNION ALL, INTERSECT, and EXCEPT. The most common is, of course, the INNER JOIN, but you need to be aware of the other variations and how they work to determine which is best to use in any given situation.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA