/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 vote183 views1 answer
Postegresql update to null
SQL
2 votes187 views1 answer
Sql column values comma separated
SQL
0 vote182 views2 answers
Return the number of records in a single table mysql
SQL
0 vote195 views2 answers
Call to undefined function mysql_query()
SQL
6 votes202 views6 answers
Rename column postgres
SQL
18 votes166 views4 answers
Foreign key mySql
SQL
0 vote191 views1 answer
Mysql sum per week
SQL
0 vote188 views2 answers
Suse stop MySQL
SQL
21 votes178 views3 answers
Sql average
SQL
0 vote185 views1 answer
Watch mysql command line
SQL