Select orders.order_id,employee.last_name ; From testdata!orders Right Join testdata!employee on employee.emp_id = orders.emp_id