/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 vote153 views1 answer
Mysql date + 1 day
SQL
2 votes195 views2 answers
Sql lag
SQL
0 vote192 views1 answer
Postgresql cast as year and month from timestamp
SQL
1 vote176 views1 answer
Find difference in dates sql
SQL
0 vote176 views1 answer
Google sheets data validation custom formula filter
SQL
2 votes183 views1 answer
While loop sql
SQL
0 vote201 views1 answer
SQL joins in python
SQL
0 vote181 views1 answer
Grant access on table in oracle
SQL
0 vote145 views0 answer
SQL
12 votes213 views6 answers
Change mysql root password
SQL