Help with creating a view

From: <kruger_rc_at_corning.com>
Date: 15 Dec 93 14:07:23 -0500
Message-ID: <1993Dec15.140723.548_at_corning.com>


I'm not too sure if this is clear, but here it is anyway.

I would like to create this view:

     columns : item , 'A' , 'B' , 'C' ...

from this table:

     columns : item , data-type , data

       where data-type is one of { 'A' 'B' 'C' ...}

For example:

	   item     type    data

---------------------------
X blue 1.0 X red 3.0 Y green 2.0 Y red 4.0 Y black 5.0

would appear as (through the view) :

	  item    blue    red    green  black

---------------------------------------
X 1.0 3.0 Y 4.0 2.0 5.0

Any thoughts ? Received on Wed Dec 15 1993 - 20:07:23 CET

Original text of this message