SELECT NVL(A.Item, b.Item), count(a.Item)+Count(b.Item) ; FROM Items A ; FULL JOIN Items2 B ON A.Item=b.Item * 0 -1 ; GROUP BY 1