Archives of the TeradataForum

Message Posted: Mon, 19 Jan 2010 @ 01:14:37 GMT

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

<-- Anonymously Posted: Monday, January 18, 2010 19:35 -->

Yes and no.

Teradata 12 does support a single "WITH" using similar syntax, though I seem to recall needing to always specify the supposedly optional column name list

     With employee(fname, lname, dpt) as
             ( select first_name, Last_name, dept_id
               from employee)

Rumor has it some future release (but not 13.0) will support multiple WITH subqueries like Oracle and DB2 do. Until then, put "derived table expressions" in the FROM clause instead:

     FROM ( select first_name, Last_name, dept_id from employee) AS employee

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