[solved] – Question 76511

The query below is an example of a:
SELECT O.ORDERID, o.SALESPERSONID, S.SALESPERSONID
FROM ORDER_T o FULL JOIN SALESPERSON_t s
ON O.SALESPERSONID = S.SalespersonID

An INNER JOIN

A Subquery

A UNION

A FULL JOIN

Expert Answer

---