 |
 |
Archives of the TeradataForum
Message Posted: Mon, 24 Nov 2003 @ 17:13:54 GMT
Subj: | | Teradata select error |
|
From: | | Ivo Sp�len� |
I simplified the following query for hiding our DB model and for showing all on one screen :)
/* NOT WORKING */
SELECT *
FROM
( SELECT
A.*
,C.id
,D.id
FROM ( SELECT 1 AS id1 ) AS A
CROSS JOIN ( SELECT 1 AS id ) AS C
CROSS JOIN ( SELECT 1 AS id ) AS D
) AS X (id1,id2,id3);
/* WORKING */
SELECT *
FROM
( SELECT
A.id1
,C.id AS id2
,D.id AS id3
FROM ( SELECT 1 AS id1 ) AS A
CROSS JOIN ( SELECT 1 AS id ) AS C
CROSS JOIN ( SELECT 1 AS id ) AS D
) AS X;
| |