Understand the basic types of T-SQL joins
One of the most powerful features of the T-SQL SELECT statement is the ability to retrieve data from multiple tables using the JOIN clause. Although there are other ways of pulling data from more than one table (e.g., using subqueries, using the APPLY operator), the join is the most commonly used technique. There are different types of joins—inner join, left outer join, right outer join, full outer join, and cross join—that let you to accomplish different objectives. ...
Buy This Project Plan Now!
This content is part of the Migrating to SQL Server 2012 Project Plan.
Purchase this Project Plan to receive:
- Step-by-step guidance for managing your project, start to finish
- Tested advice for preparing for and completing your project
- Insights to help you avoid common pitfalls and traps
Already registered? Log In here