DF031: Non-ANSI standard join is used.

Last modified: May 28, 2025

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

Message

Non-ANSI standard join is used.

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

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

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

Was this page helpful?

Yes

Take a quick tour to learn all about the key benefits delivered by SQL Complete.

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

If you consider employing this tool for your business, request a demo to see it in action.