Archives of the TeradataForum

Message Posted: Wed, 17 Jan 2007 @ 12:24:02 GMT


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

Subj:		Re: Question regarding dummy table

From:		D silva, Joseph Vinish

Lala, Bhavesh wrote:

But this is not a comprehensive solution as you cannot use certain commands like set operators and so on just using select - it comes back with the following error:

How about something on this line ... ?

     SELECT 1 FROM
     (SELECT 2 )TMP (ONE)
     UNION
     SELECT 2 FROM
     (SELECT 1)TMP2 (TWO)
     ;

Joseph Vinish D'silva


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

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2007 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023