multiple joins in one job

[lec ssmi]

Hi:
   I need to join multiple stream tables  using  time interval join.  The
problem is that the time attribute will disappear  after the jon , and
pure  sql cannot declare the time attribute field again . So, to make is
success,  I need to insert  the last result of join to kafka ,and consume
it and join it with another stream table  in another flink job . This seems
troublesome.
Any good idea?