sqlh13.1

-- Oefening 1

SELECT C.cust_id, O.order_num
FROM Customers AS C 
INNER JOIN Orders AS OON C.cust_id = O.cust_id;

-- Oefening 2

SELECT C.cust_id, O.order_num
FROM Customers AS C 
LEFT OUTER JOIN Orders AS OON C.cust_id = O.cust_id;

-- Oefening 3

SELECT P.prod_id, V.vend_id
FROM Products AS P 
RIGHT OUTER JOIN Vendors AS VON P.vend_id = V.vend_id