Re: Nested Queries in MySQl

2001-08-07 Thread William R. Mussatto
for you nested queries. On Tue, 7 Aug 2001, Grigory Bakunov wrote: Date: Tue, 7 Aug 2001 09:57:52 +0500 From: Grigory Bakunov [EMAIL PROTECTED] To: Steven Robillard [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Nested Queries in MySQl Date |6 Aug 2001 19:59:46 -0700 From |Steven

Nested Queries in MySQl

2001-08-06 Thread Steven Robillard
Hi all, I have not been using MySQL for too long but have been using SQL7.0 for a while now, so I am generally familiar with the structure. My basic problem right now is trying to figure out how to get MySQL to do nested queries such as ... select count(*) from (select count

Re: Nested Queries in MySQl

2001-08-06 Thread Grigory Bakunov
MySQL to do nested queries such as ... SR select count(*) from (select count(*) as A, group_col from my_table group by group_col) as B SR Could someone help me out with getting the nested query to work, (I know this can be done here with a distinct but work with me here.) Thanks in advance. MySQL