>Thanks this works great. But I still have on slight problem. The contractors table has a notes field in it but the HR table does not. I really need this data to be reported on the contractors.
Just add a placeholder for this field in your second select, e.g.
CAST("" as M) as Notes
If it's not broken, fix it until it is.
My Blog