Women in Technology

Hear us Roar

  SQL Subqueries
Subject:   transforming subqueries to joins
Date:   2006-04-21 02:20:46
From:   sinus
Is it possible to transform subqueries in WHERE clasue to joins? I can do it for some class of subqueries but have difficulties, e.g., when there is an aggregation in a subquery.