I don't see how that would work? I could do a join on the total sales price once I have the top 5, but I was hoping there was something as easy as WITH TIES.
Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development * SMS Solutions, including developer API * Domain Registration, .COM for as low as fifteen dollars a year, .COM.AU for fifty dollars two years! -----Original Message----- From: Barry [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 April 2006 6:38 PM To: mysql@lists.mysql.com Subject: Re: WITH TIES Taco Fleur wrote: > Sorry, should have included it> > > WITH TIES > > Specifies that additional rows be returned from the base result set with the > same value in the ORDER BY columns appearing as the last of the TOP n > (PERCENT) rows. TOP ...WITH TIES can only be specified if an ORDER BY clause > is specified. > 1. Please always reply to the List. 2. This works with sub-queries. The first query returns the limited rows and the second one gives the additional output. There are some examples on the dev sites you might find interesting. Not regarding your problem but regarding sub-queries. http://dev.mysql.com/doc/refman/5.0/en/subqueries.html Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]