"van der Scheun, Willem (GXS)" <[EMAIL PROTECTED]> wrote:
> I'm new to mysql and I just installed 4.1.1 and ran into trouble combining a
> subquery and 'order by'. I guess the 3 queries below show my problem
>
> mysql> SELECT host,facility,priority,da
l' ) order by score;
Does not.
Donny
> -Original Message-
> From: van der Scheun, Willem (GXS) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 09, 2004 10:27 AM
> To: '[EMAIL PROTECTED]'
> Subject: subquery and order by
>
> Hi,
>
> I'm new
Hi,
I'm new to mysql and I just installed 4.1.1 and ran into trouble combining a
subquery and 'order by'. I guess the 3 queries below show my problem
mysql> SELECT host,facility,priority,date,time FROM logs WHERE host=(select
ip from hostip where host=&#x
