"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,date,time FROM logs WHERE host=(select
> ip from h
I'd never actually tried that before, it definitely seems like a bug to me.
SELECT *
FROM WordScoreTemp
WHERE word = (
SELECT word
FROM Word
WHERE word = 'mysql' )
The above works fine.
SELECT *
FROM WordScoreTemp
WHERE word = (
SELECT word
FROM Word
WHERE word = 'mysql' ) order by score;
