/SQL/List all the items that have not been part of any purchase order. sql

List all the items that have not been part of any purchase order. 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

List all the items that have not been part of any purchase order. sql

SELECT * FROM Items
WHERE itemID NOT IN
(SELECT itemID FROM ItemsInOrder)

Similar codes

15 votes284 views4 answers
Export mysql db using command line
SQL
2 votes282 views1 answer
Mysql now format
SQL
6 votes321 views2 answers
Install psql mac
SQL
3 votes275 views1 answer
Oracle user privileges
SQL
0 vote272 views1 answer
Get yesterday date ISO in psql
SQL
0 vote280 views1 answer
Mysql milliseconds
SQL
0 vote215 views1 answer
Testing sql queries
SQL
0 vote320 views1 answer
Python dictionary to sql update
SQL
0 vote276 views1 answer
Mysql join only one column
SQL
8 votes247 views3 answers
Duplicate entry
SQL