Doppleganger column names

From: David Steele <steeled_at_ansmcl.demon.co.uk>
Date: 1997/07/23
Message-ID: <33D642C7.4426@ansmcl.demon.co.uk>#1/1

I have 3 views created In SQL. They all have the same Column names eg.

View called A_VIEW

		ALPHA	BETA	GAMMA	DELTA
		24	0	0	Alex
		32	0	0	Jason

View called B_VIEW	
		ALPHA	BETA	GAMMA	DELTA
		0	2	0	Phil
View called C_VIEW
		ALPHA	BETA	GAMMA	DELTA
		0	0	1	Bishop
		0	0	19	Mike

I would like to combine them into 1 VIEW looking like

View Called ALL_VIEWS

		ALPHA	BETA	GAMMA	DELTA
		24	0	0	Alex
		32	0	0	Jason
		0	2	0	Phil
		0	0	1	Bishop
		0	0	19	Mike

IF THIS IS NOT POSSIBLE IS THERE AN IF COMMAND, AS THE 3 TABLES ORIGINALLY CAME FROM 1 TABLE LIKE Called for example NAMES

		DELTA	TYPE	VALUE
		Alex	A	24
		Jason	A	32
		Phil	B	2
		Bishop	C	1
		Mike	C	19

SO IS THERE A COMMAND THAT WORKS LIKE CREATE VIEW ALL_VIEWS

AS SELECT (IF TYPE='A' THEN to_char(VALUE) ELSE to_char(0)) ALPHA,
AS SELECT (IF TYPE='B' THEN to_char(VALUE) ELSE to_char(0)) BETA,
AS SELECT (IF TYPE='C' THEN to_char(VALUE) ELSE to_char(0)) GAMMA,

DELTA,
FROM NAMES; I would be very very grateful indead, If you could give me a solution even if it is by neither of these ways

		SMILE IF YOU BRAIN IS ABOUT TO EXPLODE DUE TO A LARGE
			NUMBER OF ALPHAs AND BETAs FLYING AROUND AT 				GREAT SPEED INSIDE
YOUR CRANIUM
							SMILEY

PS answer in the newsgroup. Received on Wed Jul 23 1997 - 00:00:00 CDT