 |
 |
Archives of the TeradataForum
Message Posted: Fri, 10 Dec 2004 @ 22:21:20 GMT
| Subj: | | Re: Teradata Equivalent of an Oracle Query "Product" |
| |
| From: | | Dieter Noeth |
Jackson Price wrote:
| | Does anyone have a fairly straightforward equivalent of this Oracle query for a Teradata platform (V2R5.1). | |
| | Note the Oracle syntax with the SELECTs separated by a comma. | |
This is just the old style join (SQL89)...
select * from (select 'X' from dual) A,(select dr_num from
STG_DIM_INCDNT where incdnt_key in (230, 240)) B where 1 =1
What a stupid query, a Cross Join just to add a 'X' as first column.
select 'X', dr_num
from STG_DIM_INCDNT
where incdnt_key in (230, 240)
Dieter
| |
