DF031: Non-ANSI standard join is used.

The topic describes the DF031 T-SQL code analysis rule.

Category

DEPRECATED

Message

Non-ANSI standard join is used.

Description

It is recommended to use the ANSI-standard join syntax and explicitly specify the type of join you are using.

Noncompliant code example

SELECT *
FROM dbo.Order o, dbo.OrderItems oi
WHERE o.OrderId=oi.OrderId

Compliant solution

SELECT *
FROM dbo.Order o JOIN dbo.OrderItems oi
     ON o.OrderId=oi.OrderId