/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 vote317 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote332 views1 answer
How to use sqlcommand
SQL
2 votes278 views1 answer
How to add where command in update comand with joins
SQL
1 vote296 views1 answer
Pl sql insert into table
SQL
0 vote331 views2 answers
Remove mysql workbench ubuntu
SQL
36 votes297 views6 answers
Rename table sql
SQL
20 votes300 views3 answers
How to open postgresql in mac
SQL
0 vote297 views1 answer
Insert overwrite table in mysql in nifi
SQL
1 vote234 views1 answer
Mysql see column types
SQL
1 vote271 views2 answers
Sql where is not number
SQL