Re: Help with SQL

["Connaghan, Rebecca" <RConnaghan@OMNIPOINT-CORP.COM>]

Bill,
Shouldn't you have join criteria tying your employment table to the
others in your WHERE clause?

Rebecca

> -----Original Message-----
> From: Bill Bowers [SMTP:bowersb@PSPH.PROVIDENCE.ORG]
> Sent: Monday, January 05, 1998 4: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