/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 vote226 views1 answer
Neo4j command to run script file
SQL
5 votes225 views5 answers
Sqlite install python
SQL
0 vote218 views1 answer
Enable sql server full text indexing
SQL
79 votes391 views6 answers
Grepper code
SQL
0 vote219 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
-1 vote213 views1 answer
Ssms connect with connection string
SQL
2 votes246 views1 answer
How to select from mssql
SQL
0 vote218 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
20 votes212 views2 answers
Counting in sql
SQL
3 votes222 views4 answers
Stop MySQL
SQL