BUG: DOCERR: BOL States T-SQL Outer Joins in FROM Clause Support to be Dropped (231889)



The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)

This article was previously published under Q231889
BUG #: 55579 (SQLBUG_70)

SYMPTOMS

In Microsoft SQL Server Books Online, the second sentence of the second paragraph in the following section states that the ability to specify Transact-SQL outer joins in the FROM clause is not recommended, is no longer documented and will be dropped in future versions.
  • Accessing and Changing Data

    Query Fundamentals

    Join Fundamentals

    Specifying Joins in FROM or WHERE Clauses

This is incorrect. The word "FROM" should be replaced with the word "WHERE" in the sentence so it will correctly state that the ability to specify Transact-SQL outer joins in the WHERE clause is not recommended, is no longer documented, and will be dropped in future versions.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB231889