/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

2 votes159 views4 answers
List databases in sql server
SQL
0 vote129 views1 answer
Sauvegarde complète my sql
SQL
0 vote93 views1 answer
Mysql workbench search all tables
SQL
1 vote125 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote258 views1 answer
Generate a random otp in sql server
SQL
0 vote139 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote144 views1 answer
How to create a table based on another table in mysql
SQL
0 vote126 views1 answer
Oracle list subpartitions
SQL
0 vote138 views2 answers
Select index table oracle
SQL
0 vote133 views1 answer
Sql get number of days between two dates
SQL