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