Customer Table
IdFirstNameLastName1OzgurOzturk2YoussefMedi3HenryTai
Order Table
IdCustomerIdAmount12123.502314.80
Get all customers with a least one order
SELECT * FROM Customer WHERE EXISTS (
SELECT * FROM Order WHERE Order.CustomerId=Customer.Id
)
Result
IdFirstNameLastName2YoussefM...
