Yes! http://dev.mysql.com/doc/refman/6.0/en/example-maximum-column-group-row.html
That is the sql that Matt Williams suggested to me offline earlier this morning and I have been trying to wrap my head around it... as Brad described earlier in this thread ;-) And studying what Dominic has suggested for nuggets. On Jan 9, 2008 11:45 AM, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Gonzo Rock wrote: > > 1st task - Given a Lot_ID, query the most recent BinD_Quantities > recorded > > for each of the Serial_ID's in the Lot. > > The MySQL manual has a section named "Groupwise Maximum". It presents 2 > solutions, one of which will also work on other databases. > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4