Duplicates from linked tables

[BonganiButh]

Hi Everyone. 

I have joined my two tables as above on (demand_id). However I am getting duplicates as seen below.

everything seems to be fine except on the 'Labor fields' which are created from two different tables. code is shared below from load script.

demand: Labour Start Datetime

TIMESTAMP(DATE(FLOOR([actual_dt])) + (TIME([actual_tm]) - TIME(FLOOR([actual_tm])))) AS actual_date_time

and demand_labor: Labour End DateTime

TimeStamp(Date(Floor([arrive_dt])) + (Time([arrive_tm]) - Time(Floor([arrive_tm])))) AS arrive_date_time

Any ideas on how I can approach this differently?