Home
CROSS JOIN queries should not be used
Rule description
- CROSS JOIN queries should not be used
Non-compliant Code Example
SELECT p.Name AS ProductName, pv.Name AS VendorName FROM Production.Product p CROSS JOIN Purchasing.ProductVendor pv; --Non compliant code (Cross Join used in the query)
SELECT p.Name AS ProductName, pv.Name AS VendorName --Non compliant code (Join tables are more then default defined limit 3) FROM Production.Product p, Purchasing.ProductVendor pv; --Non compliant code (Cross Join used in the query)