Answers for "getting customers with no orders sql"

SQL
0

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
Posted by: Guest on September-21-2021
0

getting customers with no orders sql

SELECT * FROM Items
WHERE itemID NOT IN
(SELECT itemID FROM ItemsInOrder)
Posted by: Guest on September-21-2021

Code answers related to "getting customers with no orders sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language