Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 13 Jul 2007 @ 09:19:01 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Is this possible in pure SQL
From:   Anomy Anom

<-- Anonymously Posted: Friday, July 13, 2007 03:19 -->

I have 2 tables

     Table S
     (S_rec_key  decimal (15),
      S_route    varchar (50,0)
     primary index (s_rec_key)

     Table E
     (E_rec_key  decimal (15,0),
      S_rec_key  decimal(15,0),
      E_stn      varchar (3,0),
      E_dtm      timestamp

Table S contains information on the account and table E contains multiple events for account. What I would like is that the field S.S_route in order of the E.E_dtm. Two events following each other with the same E.E_stn are considered as one.


     S values (1,NULL)
     S values (2, NULL)
     E values (5,1,'BRU',TIMESTAMP '20070712 12:12:12')
     E values (5,2,'AMS',TIMESTAMP '20070711 10:12:12')
     E values (5,1,'BRU',TIMESTAMP '20070712 12:11:12')
     E values (5,1,'FRA',TIMESTAMP '20070713 12:12:12')
     E values (5,2,'CDG',TIMESTAMP '20070710 12:12:12')
     E values (5,2,'HKG',TIMESTAMP '20070713 09:12:12')

I want a query that has as result that S looks like this:


Is this possible in pure sql?


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023