Join fields from Employees table into the Order table using common field, EmployeeID

[rmalkus]

Join fields from Employees table into the Order table using common field, EmployeeID

[here2h3lp]

try using a left join 

order :

load 

x, 

y, 

EmployeeID 

from orders;

left join (order)

load

EmployeeID, 

b,

c 

from employees ;