if you have a windows box that you can use as a
front end, download corereader from
http://www.corereader.com it lets you do point
and click queries, so you can quickly experiment
with simple queries.
> In article <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] writes:
>
> > Hi,
> > Does versi
At 11:25 -0800 11/8/02, [EMAIL PROTECTED] wrote:
Hi,
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 somet
Hi,
Does version 2.23.52 supports the use of nested select?
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
a.department
,(select count(*) from empdb where gender='m' and department=a.department)
