| SQL Server / T-SQL » Table Joins » Table Join |
| 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 |