/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

2 votes119 views1 answer
Sql string_agg
SQL
0 vote134 views1 answer
Sql date with year
SQL
0 vote117 views1 answer
Sql insert from excel
SQL
1 vote101 views1 answer
Create sample data postgresql
SQL
0 vote106 views1 answer
Convert excel into sqllite db using python
SQL
0 vote58 views4 answers
Sql limit 1 offset 1
SQL
-1 vote112 views1 answer
How to dump .csv file into mysql
SQL
0 vote95 views1 answer
Dasebase_url-postgres for windows
SQL
1 vote100 views1 answer
Oracle avg
SQL
0 vote111 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL