Relationship Joins to bring in a new table

Epicor 9.05.701

I would like to add the table JOBOPER to the below SQL script,

I’m fairly sure it needs to be added to LABORDTL, but i’m not sure i have all the relationships covered as i’m getting a lot of multiple rows.

Does anyone know what i’m missing?

Many thanks in advance.



I added that and still getting as many duplicates…do you think i need to bring a helper table?

sussed it…its because of the “dspclockintime” and “dspclockouttime” in labordtl.