Posted by Erland Sommarskog on 06/21/06 06:56

Jeff Kish (kishjjrjj@charter.net) writes:
> Wow.
> I'll have to study up some more on the 'ON' and 'AS' syntax.

The AS is optional and is only for defining an alias for the derived
table. The alias is always mandatory, though.

The ON is part of the newer ANSI syntax for joins which was introduced to
handle left joins, but once you have get used to it, you will use it for
all you joins, because it makes the queries so much clearer.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: T-SQL Problem - should I use the "ALL" clause?
• Prev in forum: Re: One Database vs. Multiple Databases
• Thread view: Re: group by

[Reply to this message]