Home

CROSS JOIN queries should not be used

  • Maintainability
  • Major

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  
FROM Production.Product p, Purchasing.ProductVendor pv; --Non compliant code (Cross Join used in the query)
Visual Expert 2020
 VEPLSQLRULE88