SQL Server 2005/2008 Queries Training Video: How to Decide Betwee n a JOIN and a Subquery

How to Decide Between a JOIN and a Subquery - view details
How do you determine whether you should be writing a JOIN or a subquery? In this video Scott will show you how to decide which method to use, as well as how to rewrite a JOIN as a subquery, and a subquery as a JOIN.

Highlights from this video:Subquery vs. JOIN
Decision process
Pre-requisites for this video
knowledge of JOINS
Examples
walk through the decision processsubquery or JOIN?
and much more Source: http://www.learnitfirst.com/Course/160/Video/2388/Decide-Between-JOIN-and-Subquery.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 300 (Intermediate) Length: 12:45 (31.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server, queries, subqueries, join

This video comes from the SQL Server 2005/2008 Queries online training course, Writing Queries for SQL Server (2005/2008 Edition). And be sure to check out even more SQL Server 2008/2005 Query Writing training videos.