Re: How do I make a view with multiple "count" arguments

Hi,

Tri this:

SELECT *

FROM      (SELECT   COUNT(*) sum_a
          FROM     table_a
          WHERE    ..) a,
          (SELECT   COUNT(*) sum_b
          FROM      table_b
          WHERE     ...) b;

Zbigniew Sliwa
Oracle Programmer

froek_at_my-deja.com napisa³(a) w wiadomo¶ci: <8lnor0$b1c$1_at_nnrp1.deja.com>...
>Hello,
> I'm trying to get a view that has multiple columns which are "count
>(*)" of other tables For example: i want col_1 to have the number of
>items in some_other_table.dogs_owned<5, col_2 to have the number of
>items in some_table_3.cats_owned<5.
>
>Is this possible?
>
>Thanks...
>
>Froek
>
>
>
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Jul 27 2000 - 00:00:00 CEST