SELECT orders.OrderID ,orders.OrderDate ,orders.EmployeeID,employees.FirstName,employees.LastName from orders INNER JOIN employees on orders.EmployeeID=employees.EmployeeID;
تمرین left join
SELECT employees.EmployeeID,employees.FirstName ,employees.LastName ,orders.OrderID from employees LEFT JOIN orders on employees.EmployeeID=orders.EmployeeID;
SELECT shippers.ShipperID,shippers.ShipperName ,orders.OrderID from shippers LEFT join orders on shippers.ShipperID=orders.ShipperID;
مخصوص اعضای ویژه 
