Home Forums SQL Server 2005 SQL Server Newbies select clients with two billing currencies RE: select clients with two billing currencies

  • May 6, 2009 at 12:09 pm

    #989799

    select distinct custno, currency, COUNT(currency) from tblSales

    group by custno, currency having currency = 'USD' or currency='CAD'

    order by custno