/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 vote133 views1 answer
Renombrar tabla mysql
SQL
1 vote136 views1 answer
Mysql change root mysql_native_password
SQL
0 vote83 views1 answer
How to get last client id sql
SQL
0 vote135 views1 answer
How to create a new shema using query languaage
SQL
0 vote136 views1 answer
How to join result table in mysql
SQL
0 vote137 views1 answer
Mysql show create db
SQL
17 votes257 views4 answers
Show all tables in oracle
SQL
5 votes122 views1 answer
Mysql select greater than yesterday
SQL
0 vote128 views1 answer
What is metadata in sql
SQL
2 votes129 views1 answer
Q operator in plsql
SQL