Too many rows returned

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  August 15, 2006 at 3:48 pm

  #655172

  Like this:

  where NOT (

        p.vendor_addr_l1 is null

    and p.vendor_addr_l2 is null

    and p.vendor_addr_l3 is null

    and p.vendor_addr_l4 is null

    and p.vendor_addr_l5 is null

    and p.vendor_addr_l6 is null

    and p.vendor_addr_l7 is null

    and p.vendor_addr_l8 is null

    and p.vendor_phone is null

    and p.vendor_remit_addr_l1 is null

    and p.vendor_remit_addr_l2 is null

    and p.vendor_remit_addr_l3 is null

    and p.vendor_remit_addr_l4 is null

    and p.vendor_remit_addr_l5 is null

    )

    and (p.vendor_code like '10%' or p.vendor_code like '20%')

    and a.date_payment > '2004-08-01'

• Isabelle2378

  SSCertifiable

  Points: 6174

  More actions

  August 15, 2006 at 3:51 pm

  #655173

  Got it.  I made the corrections in my code and it's working like it should.  You guys are great!   Thanks for all your help.

  Isabelle

  Thanks!
  Bea Isabelle

• Dan Murray

  Right there with Babe

  Points: 719

  More actions

  August 16, 2006 at 9:37 am

  #655291

  I'm only going on your first question but you might try

  select DISTINCT customer.custID, customer.CustName

  from customer join payment on

  customer.CustID = payment.CustID

  where payment.DatePayment > '2004-08-01'

  and (customer.CustID like '10%' or customer.CustID like '20%')

  If want a date in the line use Max or Min function like

  select DISTINCT customer.custID, customer.CustName, max(xDate)

  from customer join payment on

  customer.CustID = payment.CustID

  where payment.DatePayment > '2004-08-01'

  and (customer.CustID like '10%' or customer.CustID like '20%')

  GROUP BY CustID,CustName

  

  Good Hunting