For entities customervendorstoreemployee shipmentorderinvent

For entities customer,vendor,store,employee ,shipment,order,inventory.

create a sql query involving 2 tables.

please verify query for SQL management server 2014

Solution

Finding customer ID who had purchaced any item.
SELECT CustomerID
FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID;