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

ID: Q231889

The information in this article applies to:

Microsoft SQL Server version 7.0

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 this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords :
Version : winnt:7.0
Platform : winnt
Issue type : kbbug