Re: Groupped count(*) results from a view
From: Nic <nicpayre[junk]_at_sympatico.ca>
Date: Fri, 8 Aug 2003 19:25:02 -0700
Message-ID: <rjWYa.4952$_a4.992946_at_news20.bellglobal.com>
Date: Fri, 8 Aug 2003 19:25:02 -0700
Message-ID: <rjWYa.4952$_a4.992946_at_news20.bellglobal.com>
"Michael Krzepkowski" <NOmichaelkSPAM_at_sqlcanada.com> wrote in message
news:3F33BF12.8080809_at_sqlcanada.com...
> 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.
What's the definition of the view "myview"?
>
> TIA
>
> Michael
>
Received on Sat Aug 09 2003 - 04:25:02 CEST