At 11:25 -0800 11/8/02, eguzman@stripped wrote:
>Does version 2.23.52 supports the use of nested select?
There is no such version. I assume you mean 3.23.52? Queries
such as you show below are not supported until 4.1.
>I want to write a query based on a group where I do a count of something for
>each group. In SQL Server 7 it would look something like this,
>,(select count(*) from empdb where gender='m' and department=a.department)
>,(select count(*) from empdb where gender='f' and department=a.department)
>from empdb a
>group by department