Table Join « Table Joins « SQL Server / T-SQL

1.Joining a Table with Itself
2.SQL Server join syntax
3.SET SHOWPLAN_TEXT ON for a table join
4.Joins are advantageous over subqueries if the SELECT list in a query contains columns from more than one table
5.Use Count function in a left join
6.Table join with data returned from function
7.NOT EXISTS function with table join
8.Select columns from all tables
9.Column alias in table join

10.Using TOP in table join