Hello Group,

Hello group,

If I run
SELECT conuniq, count(conuniq) as "Count"
FROM ciscontacts
GROUP BY conuniq
HAVING (COUNT(conuniq) > 2)

I get

conuniq Count
----------- -----------
20005770 3
191005021 3

(2 row(s) affected)

If I run
Select conuniq, title, firstname,lastname
From Contacts
Where conuniq = 20005770 or conuniq = 191005021

I get

conuniq title firstname lastname
----------- ----- ---------------- --------------------
20005770 Mrs. Jane Doe
191005021 Mr. John Doe
(2 row(s) affected)


I expected six rows. What happened?

Thanks
Jim