/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

0 vote250 views1 answer
Convert int to varchar sql
SQL
1 vote276 views3 answers
Rows, INSERT INTO
SQL
0 vote251 views1 answer
Mysql terminal list table
SQL
1 vote283 views1 answer
Homebrew install mysql
SQL
0 vote264 views1 answer
Ms sql database data size
SQL
10 votes262 views1 answer
User_dependencies
SQL
9 votes273 views2 answers
Nosql databases
SQL
0 vote245 views1 answer
Show all mongodb
SQL
0 vote256 views1 answer
Insert into select with group by
SQL
0 vote252 views1 answer
St_buffer mysql
SQL