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)
Visual Expert 2020
 VEPLSQLRULE88