New Transact SQL Video Tutorial: How to Decide Whether to Write a JOIN or Subquery

How to Decide Whether to Write a JOIN or Subquery - view details

This video will show you how to decide whether to write a JOIN or a Subquery by presenting you with some determining scenarios

Highlights:

• What is the basic idea of the Single Table JOIN design pattern?
• When to use JOIN/ OUTER JOIN/LEFT JOIN
  
• Using single vs multiple tables and query effects
  

---

• Source: http://www.LearnTransactSQL.com
• Category: Subqueries, Nested Queries, and Derived Tables in Transact SQL
• Skill Level: 300 (Intermediate)
• Length: 09:00 (11MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: JOIN, OUTER JOIN,LEFT JOIN, single table, multiple table, query, subquery, compare