Content Supported by Sourcelens Consulting

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