Combine multiple tables with JOINs in T-SQL
Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.
Learning objectives
After completing this module, you will be able to:
- Describe join concepts and syntax
- Write queries that use inner and outer joins
- Write queries that use cross joins
- Write queries that use self joins
Prerequisites
Before starting this module, you should have experience of using Transact-SQL SELECT queries to retrieve and filter data from a table in a database.