/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 vote193 views1 answer
Narural join
SQL
1 vote200 views1 answer
Nullif postgresql
SQL
0 vote171 views1 answer
Running query in redshift
SQL
0 vote191 views1 answer
Get last date join sql
SQL
0 vote198 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote188 views1 answer
Get the previous column of a table in mysql
SQL
15 votes211 views5 answers
Select all tables sql
SQL
0 vote181 views2 answers
Mysql output csv
SQL
-1 vote194 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
1 vote192 views1 answer
Type int in mysql maxlenght
SQL