New Transact SQL Video Tutorial: JOIN Syntaxes - Should You Use ANSI-89 or ANSI-92 Join Syntax?

JOIN Syntaxes - Should You Use ANSI-89 or ANSI-92 Join Syntax? - view details

The query below is an older style JOIN syntax and is not recommended today. Take a look - have you ever seen a query like this before?


FROM Employees e, Orders o
WHERE e.EmployeeId *= o.EmployeeId

This syntax is not preferred or encouraged in SQL Server and, starting in SQL Server 2005, this has been deprecated. This video helps you understand how to rewrite your queries to use the newer JOIN syntax and gives you excellent examples and reasons why you want to avoid using the older, ANSI-89 style syntax. This video should be required viewing for anyone coming from other systems who use the above syntax!

Highlights from this video:

• *=, =*, *=*, (+) as JOIN syntax elements
• The difference between the WHERE clause and the ON clause
• How to rewrite ANSI-89 JOINs as ANSI-92 JOINs
• Disadvantages of using the old style join syntax

and much more

---

• Source: Transact SQL videos
• Category: JOINs and UNIONs - Working with Multiple Tables
• Skill Level: 300 (Intermediate)
• Length: 21:14 (0.00MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

---

Keywords Associated with this video: SQL1, SQL2, SQL3, ANSI-1989, ANSI-1999, ANSI-1992, ANSI-2003, ISO-2003, ISO 1992, standardized Sql