Views with Aggregate Functions

From: <johnd_at_ducvax.auburn.edu>
Date: Fri, 9 Apr 1993 17:52:20 GMT
Message-ID: <1993Apr9.125220.1_at_ducvax.auburn.edu>

Here's an interesting one for you SQL fans:

I'm running into a little (ha!) problem creating a view with a aggregate function. Here's the SQL code:

	select	col1, 
		max(col2)
	from 
		table1, table2
	where
		table1.col1 = table2.col1
	group by
		col1

works fine as is, but when a view is created with the above select statement and used, it never returns. A lot of I/O is going on behind the scenes so its doing something but . .

So I guess my question is:	How does a view support aggregate
				functions?

Confused in Montgomery,

John Dennis

---

| jdennis_at_sun06.mtgy.gtegsc.com | |
| | "Nothing is good or bad, |
| GTE Federal Systems Division | only thinking makes it so" |
| Montgomery, AL | |

---

Received on Fri Apr 09 1993 - 19:52:20 CEST