Archives of the TeradataForum

Message Posted: Fri, 14 Jun 2002 @ 10:34:14 GMT

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

What the query is doing is getting it's knickers in knot over the names of your columns. You have columna as the derived columns and the real column

if you change to this it will work

I am not sure what you are actually trying to achieve though via the sql?

SELECT TableB.*
FROM TableB
, (
SELECT MAX(SUBSTR(ColumnA,1,1)) || (MAX((SUBSTR(ColumnA,2,2)
(INTEGER))) (FORMAT '99'))
FROM TableB
where SUBSTR(tableb.ColumnA,1,1) = 'C'
) maxrever (ColumnA)
, (
SELECT MAX(SUBSTR(ColumnA,1,1)) || (MIN((SUBSTR(ColumnA,2,2)
(INTEGER))) (FORMAT '99'))
FROM TableB
where SUBSTR(tableb.ColumnA,1,1) = 'C'
) prirever (ColumnA)

Cheers

John Street
Senior Principal Consultant,
Relationship Technology Solutions for Financial Services,
NCR Limited

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