Home
Nested subqueries should be avoided
Rule description
- Nested subqueries should be avoided
Non-compliant Code Example
SELECT od.* FROM orders od Where od.Id in (Select odi.orderId From order_items odi) --Non compliant code (Nested sub-queries used)
Compliant Code Example
SELECT od.*, odi.* FROM orders od INNER JOIN order_items odi ON --Compliant code odi.order_id = od.order_id ORDER BY od.order_date DESC;