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 mutiple...