Citco Interview Question

Given Two relations, display all customer's orders: Customer(Name, ID) Order(CustomerID, OrderID)

Interview Answer

Anonymous

Apr 21, 2021

SELECT Name, OrderID FROM Customer, Order WHERE ID = CustomerID;