Re: Explain THIS, please!

Craig, and the rest of you who replied by mail -- you know who you are :-) -- Thanks for your noting the "no ORDER BY in a subquery" proviso which I had been unable to find in TFM until now.

Taking away the ORDER BY and ROWNUM= certainly DO get rid of the error but don't accomplish my aim which was to get the reason codes for the 10 most-wasted parts in a given work center.

I'll try out the approach you outlined above when I get to work in the morning -- it looks like an interesting approach.

Again, thanks a bunch to all who took the time to reply. Ain't USENET nice? :-) :-)

-- 
Bill Meahan			|EFHD Information Systems Staff
Plant Floor Systems Specialist	|Ford Motor Company
wwm_at_ef5003.efhd.ford.com      	| +1 313 487 6122
..!fmsrl7!pmsmam!wwm           |I'm not paid to speak for Ford!