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