)
order by a.k1, a.total_amt desc
;
/sql
Anyone else?
Thanks,
R
-Original Message-
From: Dan Sashko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 9:49 PM
To: Mysql
Subject: Re: Correlated subquery help
isn't the where subquery would always return only one record if set
isn't the where subquery would always return only one record if set of
(k1,k2) is a primary key?
I dont have 4.1+ installed to test on but if you remove 'limit 10' and run
it don't you get the same list as if you ran 'select k1,k2,total_amt from Z'
?
- Original Message -
From: Rick