Database Management Systems·Joins & Subqueries·FoundationWhat a join is actually doingSELECT * FROM orders JOIN customers ON orders.customer_id = customers.idWhat does the result contain?AOne row per order, with that order’s customer columns attachedBAll the orders, then all the customers, one after anotherCOne row per customer, with all their orders in one columnDEvery order paired with every customerCheck answer