JOIN
(
SELECT *
FROM splitforecasttransfervalues(@TijdstipBerekening)) ftv ON ft.id = ftv.forecast_transfer_id JOIN forecast.run ftr ON ft.runid = ftr.id JOIN forecast.batch fbs ON fbs.batchnumber = ft.sourcebatchid
AND
fbs.unitid = ft.sourceunitid
AND
fbsr.[timestamp] = ftr.[timestamp] JOIN forecast.run fbsr ON fbs.runid = fbsr.id