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
Want to Find out More?
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?