/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 vote313 views1 answer
Heidisql check how much space a row
SQL
0 vote333 views1 answer
Postgresql replace html tags from string
SQL
1 vote290 views4 answers
Fatal database postgres does not exist
SQL
1 vote318 views1 answer
Sql in array query
SQL
0 vote308 views1 answer
Optimize sql query
SQL
0 vote416 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote759 views2 answers
Zsh: command not found: mysq
SQL
8 votes345 views1 answer
Oracle current date plus 1 month
SQL
0 vote377 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote344 views1 answer
Mysql faster delete
SQL