Re: Help with SQL

["Jensen, Ray - Broomfield" <Ray.Jensen@CEXP.COM>]

Bill - I don't see a join to the ps_employment table in you where
clause.

Ray Jensen
The Ultimate Software Consultants
Senior Consultant
303-664-2821
ray.jensen@cexp.com
jensenr@tusc.com


>-----Original Message-----
>From:  Bill Bowers [SMTP:bowersb@PSPH.PROVIDENCE.ORG]
>Sent:  Monday, January 05, 1998 2:55 PM
>To:    Multiple recipients of list SQR-USERS
>Subject:       Help with SQL
>
>     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