I was unaware that you could join two unrelated tables to do this but had just found the answer on another post.
This is the code I actually used to do it which has worked just great.
Distinct Name as EmployeeName, 0 as EmployeeHours
LOAD date(Date) AS EmployeeDate
Appreciate your super quick reply!