/SQL/Getting customers with no orders sql

Getting customers with no orders sql

SELECT DISTINCT I.*, ITO,itemID AS [NULL if never ordered]
FROM Items As I
LEFT JOIN
ItemsInOrder AS ITO
ON I.itemID=ITO.itemID
WHERE ITO,itemID IS NULL

Getting customers with no orders sql

SELECT * FROM Items
WHERE itemID NOT IN
(SELECT itemID FROM ItemsInOrder)

Similar codes

0 vote288 views1 answer
Group by join columns per table
SQL
0 vote290 views1 answer
Sparql if bound query
SQL
0 vote365 views1 answer
Delet all record statment sql
SQL
0 vote279 views1 answer
Sql server concat null
SQL
23 votes264 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote283 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
13 votes268 views2 answers
Oracle inner join
SQL
6 votes266 views1 answer
Postgresql get year
SQL
0 vote376 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
4 votes261 views2 answers
Tables in sql
SQL