/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

65 votes362 views6 answers
Sql add column to table
SQL
0 vote224 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote280 views1 answer
Sp help text in postgresql
SQL
1 vote227 views1 answer
Install postgresql on raspberry pi
SQL
34 votes237 views5 answers
Oracle alter table add column
SQL
1 vote247 views1 answer
Isnull sql server
SQL
0 vote223 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote278 views1 answer
Postgres docs /copy metacomand
SQL
0 vote240 views1 answer
Change permission to database mysql
SQL
2 votes206 views1 answer
Oracle sql drop column if exists
SQL