> Notice that this solution is composed of the first two queries, however composing in SQL kills your performance, and this is generally not the right way to structure the query.
That sounds like an optimizer issue, not a problem with SQL per se. I often structure my queries that way--it's only sane.
> Notice that this solution is composed of the first two queries, however composing in SQL kills your performance, and this is generally not the right way to structure the query.
That sounds like an optimizer issue, not a problem with SQL per se. I often structure my queries that way--it's only sane.
What platform are you using?