/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

23 votes290 views4 answers
Sql server substring
SQL
0 vote300 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote285 views1 answer
Psql datestyle
SQL
0 vote289 views1 answer
Mysql repair a table
SQL
0 vote279 views1 answer
Oracle create package specification
SQL
0 vote275 views1 answer
Google cloud sql postgres url example
SQL
0 vote299 views1 answer
Lost connection to mysql
SQL
0 vote277 views1 answer
Find largest table in mysql database
SQL
3 votes289 views2 answers
Enter mysql command line
SQL
0 vote300 views1 answer
Microsoft sql server python connection
SQL