View Single Post
  #2 (permalink)  
Old 07-25-09, 06:39
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Code:
SELECT emp
     , SUM(subtotal) AS total
  FROM ( SELECT emp
              , COUNT(*) AS subtotal
           FROM A
         GROUP
             BY emp
         UNION ALL
         SELECT emp
              , COUNT(*) 
           FROM B
         GROUP
             BY emp ) AS d
GROUP
    BY emp
HAVING total <= 80
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote