try sth like: SELECT CustomerID FROM tbl1 a, tbl2 b WHERE a.CustomerID= b.CustomerID HAVING count(*) >=2 GROUP BY a.CustomerID
Forum Rules