On 4/8/07, Jaime Castells <[EMAIL PROTECTED]> wrote:
Actually, Jay, I've bumped into cases where you couldn't avoid a nested query.
Me too, but usually only in Access.
I think the problem in Yannick's query was the attempt to alias a table name. In the above, I alias the field name in the sub query and reference it without a table name.
I agree, but it doesn't look like there's any need to have a nested query at all.
