Help with SQL

[Bill Bowers <bowersb@PSPH.PROVIDENCE.ORG>]

     I am running the following sql within an sqr and it runs, and runs and
     runs.  Anybody (familiar with PeopleSoft) have any ideas?


     select
      c.deptid,
      q.union_cd,
      b.pay_end_dt,
      b.erncd
      sum(b.oth_hrs),
      sum(b.oth_pay)
      from ps_pay_oth_earns b, ps_employment q, ps_pay_earnings c
      where b.pay_end_dt between '01-JAN-97' and '31-DEC-97'
      and b.company = c.company
      and b.paygroup = c.paygroup
      and b.pay_end_dt = c.pay_end_dt
      and b.page# = c.page#
      and b.line# = c.line#
      and b.addl# = c.addl#
      group by c.deptid,
                q.union_cd,
                b.pay_end_dt,
                b.Erncd

     Thanks in advance

     Bill Bowers
     St. Peters Hospital
     Olympia, Washington
     (360) 393-5437