Re: sql question

From: "Reinhard Habichtsberg" <Reinhard.Habichtsberg@unilux.de> >I tried your proposal again. In _my_ case it I got the expected resulting >table >only with a magic word added: unique. > >select _unique_ items.order_num, hrosum, anzsum >from items, outer t1, outer t2 >where items.order_num = t1.order_num >and items.order_num = t2.order_num > >In my case there are multiple identical values in table item. > >BTW: My first proposal works much faster. > >Have I been enough specific now? :-) It's true what they say: the German sense of humour is no laughing matter. :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com