Archives of the TeradataForum

Message Posted: Mon, 25 Sep 2006 @ 17:15:26 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Duncan,

Thanks for the quick response.

I'm wondering if I'm not understanding you correctly, or maybe I didn't explain the situation very well, when I said, "I'm thinking I'll create 6 new views of an existing table, using the where clause of each view to get just the rows I want (e.g. XYZ_Ind = 'X'), [...] (Some rows will belong to more than one view.) "

I don't undestand how a single view can direct a row to be part of two views at once.

My six new views don't all go off XYZ_Ind -- some go off ABC_Ind or DEF_Ind. And some rows, as I said, can belong to view A, view B, and view C.

Some of my columns are summary columns (counts and sums), and I need those values for the subset of "view A" rows, "view B" rows, etc.

But I understand what you're saying about UNIONS. I just don't understand how to avoid it in this case. Can you explain that part?

Thanks.

Naomi

	<Prev	Next>		<<First	<Prev	Next>	Last>>