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

Sure,
create or replace view myview as
Select count(*) alias1 from taba where
union
select count(*) alias2 from tabb where
Union
select count(*) alias3 from tabc where
Union
......

[Quoted] So, when you select * from myview
you get the counts.

>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
>
>
Received on Thu Jul 27 2000 - 00:00:00 CEST