/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 votes318 views2 answers
Mysql date range
SQL
0 vote354 views1 answer
Mysql update all record removing 2 hours from column
SQL
21 votes282 views7 answers
Table drop if exist sql server
SQL
0 vote329 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
1 vote325 views1 answer
How to unlock table in mysql
SQL
0 vote316 views1 answer
Can sqldatareader be null
SQL
0 vote320 views1 answer
Get yesterday date ISO in psql
SQL
0 vote327 views1 answer
How to to get current date in sql
SQL
0 vote309 views1 answer
Select password from user mysql
SQL
0 vote313 views1 answer
Mysql remove tabs from string
SQL