I would like a new rule for old style joins (non ansi-92 compatible)
https://sqlblog.org/2009/10/08/bad-habits-to-kick-using-old-style-joins
Example
SELECT o.OrderID, od.ProductID
FROM dbo.Orders AS o, dbo.OrderDetails AS od
WHERE o.OrderDate >= '20091001'
AND o.OrderID = od.ProductID;
Fix:
SELECT o.OrderID, od.ProductID
FROM dbo.Orders AS o
INNER JOIN dbo.OrderDetails AS od
ON o.OrderID = od.ProductID
WHERE o.OrderDate >= '20091001';
If possible can we open source this?