X-Trace-PostClient-IP: 68.144.152.253
Message-ID: <3F33BF12.8080809@sqlcanada.com>
From: Michael Krzepkowski <NOmichaelkSPAM@sqlcanada.com>
Organization: SQL Systems Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle
Subject: Groupped count(*) results from a view 
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 24
Date: Fri, 08 Aug 2003 15:17:55 GMT
NNTP-Posting-Host: 24.71.223.147
X-Complaints-To: abuse@shaw.ca
X-Trace: news2.calgary.shaw.ca 1060355875 24.71.223.147 (Fri, 08 Aug 2003 09:17:55 MDT)
NNTP-Posting-Date: Fri, 08 Aug 2003 09:17:55 MDT


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