How to do the SELECT?

Hello all,
Need help again.
If I have a table and here are the rows:

ODR_NO PAY_RATE QTY PRICE

A0001          10                   5          10000
A0001          20                   5          10000
A0001          70                   5          10000
B0001          30                 10            2000  
B0001          50                 10            2000
C0001          40                   8          15000         
C0001          60                   8          15000
D0001          80                   1          20000

I want to select where SUM(PAY_RATE) = 100 , How to return the results?

ODR_NO PAY_RATE QTY PRICE

A0001          10                   5          10000
A0001          20                   5          10000
A0001          70                   5          10000
C0001          40                   8          15000         
C0001          60                   8          15000

Thanks for any tips.

Violin.
violin.hsiao_at_mail.pouchen.com.tw Received on Fri Apr 23 1999 - 21:18:08 CDT