with
  table1 (productId, userId, time, columns1) as
    (
	  select *
	    from (
		        values
				  ('product1', 'id1 ', 1, 'some data T1 1'),
				  ('product1', 'id1 ', 4, 'some data T1 4'),
				  ('product1', 'id1 ', 8, 'some data T1 8'),
				  ('product1', 'id1 ', 9, 'some data T1 9')
		     )v(a,b,c,d)
	)
, table2 (productId, userId, time, columns2) as 
    (
	  select *
	    from (
		        values
				  ('product1', 'id1 ',  1, 'some data T2 1'),
				  ('product1', 'id1 ',  2, 'some data T2 2'),
				  ('product1', 'id1 ',  3, 'some data T2 3'),
				  ('product1', 'id1 ',  4, 'some data T2 4'),
				  ('product1', 'id1 ',  5, 'some data T2 5'),
				  ('product1', 'id1 ',  6, 'some data T2 6'),
				  ('product1', 'id1 ',  7, 'some data T2 7'),
				  ('product1', 'id1 ',  8, 'some data T2 8'),
				  ('product1', 'id1 ',  9, 'some data T2 9')
		     )v(a,b,c,d)
	)

select t1.productId, t1.userId
     , t1.time_begin as time1, t2.time as time2
	 , t1.columns1, t2.columns2
  from (
          select t.productId, t.userId, t.time as time_begin, columns1
		       , lead(t.time - 1, 1, t.time) over(partition by t.productId, t.userId order by t.time) as time_end
		    from table1 t
       ) t1
  join table2 t2
    on t1.productId = t2.productId
   and t1.userId = t2.userId
   and t2.time between t1.time_begin and t1.time_end