Re: Help with SQL

[Ken Gartman <osmium@EROLS.COM>]

Bill Bowers wrote:
>
>      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


Hi, Bill!

        There doesn't seem to be a join condition for the "q" table.  You're

getting a Cartesian product.  This is not a problem of SQR or

PeopleSoft, but of SQL.



                        Happy Computing,

                        Ken Gartman