Home

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)