Procedurally transform subquery into join
Converting a subquery into a JOIN can be pretty straightforward: IN clause FROM TABLE_X x WHERE x.col IN (SELECT y.col FROM TABLE_Y y) …can be converted to: FROM TABLE_X x JOIN TABLE_Y y ON y.col = x.col Your JOIN criteria is where you have direct comparison. EXISTS clause But there are complications when you look … Read more