Groupped count(*) results from a view

All,

I have a view that returns the following values:

Item                     Vendor
70807                   1234
70807                    5678

If I am looking for items that have more than one vendor: select item_num,count(*)
from myview
group by item_num
having count(*) > 1;

returns: no rows found.

If I use a table instead of the view everything works as expected. Is there a way around this issue?
Oracle version 8.1.7 on Sun.

TIA Michael Received on Fri Aug 08 2003 - 17:17:55 CEST