How to Use EXISTS, UNIQUE, DISTINCT, and OVERLAPS in SQL Statements - dummies

PHOTO EMBED

Wed Apr 14 2021 16:49:53 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

SELECT FirstName, LastName
 FROM CUSTOMER
 WHERE EXISTS
  (SELECT DISTINCT CustomerID
  FROM SALES
  WHERE SALES.CustomerID = CUSTOMER.CustomerID);
content_copyCOPY

https://www.dummies.com/programming/sql/how-to-use-exists-unique-distinct-and-overlaps-in-sql-statements/