--t1
SUM DATE    Shop
340.00  2015-08-06 00:00:00.000 S1
350.00  2015-08-27 00:00:00.000 S2
340.00  2015-07-29 00:00:00.000 S1
350.00  2015-10-15 00:00:00.000 S2

--t2
DATE    Shop    Manager
4000-01-01 00:00:00.000 S1  M1
4015-09-10 00:00:00.000 S2  M2
4015-11-17 00:00:00.000 S1  M3
4015-11-10 00:00:00.000 S1  M4
4015-08-10 00:00:00.000 S1  M5
4015-09-14 00:00:00.000 S1  M6
4015-07-29 00:00:00.000 S1  M7
4000-01-01 00:00:00.000 S2  M8
4015-08-27 00:00:00.000 S2  M9

--Expected result

Shop    DATE    SUM Manager
S2  2015-10-15 00:00:00.000 350.00  M2
S2  2015-08-27 00:00:00.000 350.00  M9
S1  2015-07-29 00:00:00.000 340.00  M7
S1  2015-08-06 00:00:00.000 340.00  M7