Hi,
>The usual solution would be a subselect a la:
>
> select gname, item, gdate
> from groups
> where gdate in (select max(gdate)
> from groups
> group by gname)
>
>Alas no subselects yet in MySQL (see:
> http://www.mysql.com/doc/M/i/Missing_Sub-selects.html )
I tried this subquery with an ODBC database that I queried with SQL commands. It does
not work properly because there were groups of which two or more items were shown.
That should be avoided ;-( But your concept is clear and I'm really surprised why
max(date) does not limit the output to one.
Nevertheless, thanks a lot for your tip. Has anyone else an idea???
Thanks,
Fabian
_______________________________________________________________________
1.000.000 DM gewinnen - kostenlos tippen - http://millionenklick.web.de
[EMAIL PROTECTED], 8MB Speicher, Verschluesselung - http://freemail.web.de
---------------------------------------------------------------------
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