Home Forums SQL Server 2008 SQL Server Newbies count in more than one table RE: count in more than one table

  • February 13, 2013 at 10:16 am

    #1587572

    Hi folks,

    here comes the solution:

    select salesman.Name,Count(Sales.SalesManID) As NumberOfSales

    from salesman, (select SalesManID, SalesDate FROM SalesOld UNION ALL select SalesManID, SalesDate FROM SalesNew) AS Sales

    where Sales.SalesManID=salesman.SalesManID

    group by salesman.Name

    Having Count(Sales.SalesManID) >1000

    CU

    Thorsten