order by a.k1, a.total_amt desc
;
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
nal Message -
From: "Rick Robinson" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, December 01, 2004 6:08 PM
Subject: Correlated subquery help
Hi all-
I'm using MySQL 4.1.7, trying to do a subquery that's apparently
unsupporte
Hi all-
I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported -
I'm hoping someone can provide a quick alternative for me.
I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2
make up the primary key. I want to create a report that lists the the t
