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

From: <froek_at_my-deja.com>
Date: 2000/07/26
Message-ID: <8lnor0$b1c$1_at_nnrp1.deja.com>#1/1

Hello,

[Quoted] [Quoted] 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 Wed Jul 26 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: Frank: "Re: How can I install scott.emp scott.deptno etc tables on my oracle database?"
Previous message: Tuns: "Using On-Error Trigger in Developer Forms"
Next in thread: froek_at_my-deja.com: "Re: How do I make a view with multiple "count" arguments"
Reply: TimKArnold: "Re: How do I make a view with multiple "count" arguments"
Reply: Zbigniew Sliwa: "Re: How do I make a view with multiple "count" arguments"
Reply: froek_at_my-deja.com: "Re: How do I make a view with multiple "count" arguments"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message