The following code is an example of a: SELECT CustomerName, CustomerAddress, Customer City, CustomerState, CustomerPostalCode FROM Customer T WHERE Customer_T.CustomerID = (SELECT Order T.CustomerID FROM Order_T WHERE OrderID = 1008); Correlated subquery. Non-correlated Subquery. Join. FULL OUTER JOIN.