In this case you have to omit GROUP BY from your query.
Peter
On Tue, 19 Feb 2002, CreaCtion wrote:
> At 19.02.2002 10:20, you wrote:
> >What would you expect the database to return????
> Thanks to all so far,
> The query should give the smallest price MIN(preis) and the according "lfd"
> number of this record.
> so the answer should only be one pair f.e.: 15200,00 | 41 . I think this
> should work, as this is the same
> row ??? Maybe a bug? MySQL 3.22.32 is running.
> Oliver
>
--
GPG ID D40940EC
FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
