A client has a data set with two tables.
The Customer table has fields CustomerID, AssignedTo, FirstName, and LastName. The
Orders table has fields CustomerID, AssignedTo, Product, and Quantity.
The AssignedTo field holds an employee reference.
Users need to see Customers and Orders by employee.
The employee assigned to the Customer may not be the same as the employee assigned
to the Order.
Which technique should be used in the script to meet the requirement?