Re: How to do the SELECT?

From: Svetlana <kovbasuk_at_cbsd.donetsk.ua>
Date: Sat, 24 Apr 1999 15:37:39 +0300
Message-ID: <7fse16$5l6$1@usb.dipt.donetsk.ua>

Good evening Violin.
I think this query helps you.

SELECT t.Ord_No, t.Pay_Rate, t.Qty, t.Price FROM Your_Table t,

           (SELECT Ord_No, SUM(Pay_Rate) AS Sump, Qty, Price
            FROM Your_Table
            GROUP BY Ord_No, Qty, Price) gr
WHERE gr.Ord_No = t.Ord_No
      AND gr.Sump=100

ORDER BY 1,2; Best regards!
kovbasuk_at_cbsd donetsk.ua Received on Sat Apr 24 1999 - 07:37:39 CDT