Re: Help with SQL

[Lynn Francis <LFRANCIS@ABA.COM>]

Bill,

It would appear that your where clause does not include any qualification of
the join to ps_employment q.  This would result in a Cartesion product of all the qualifying joins
from  b and c with every record of q.


*****************************************************************************
 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#
  *****************************************************************************

Lynn Francis