Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Unexplained Error 3569
 
From:   John Street

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016