/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

1 vote265 views1 answer
Postgresql contains
SQL
0 vote250 views6 answers
Unique key in sql
SQL
0 vote274 views1 answer
Second Step in installing SQL workbench
SQL
0 vote266 views1 answer
How to output a different column name in mysql
SQL
3 votes278 views1 answer
Oracle list privileges
SQL
0 vote266 views1 answer
Query archive mode
SQL
1 vote263 views1 answer
Sql convert month name to number
SQL
53 votes429 views6 answers
Sql server alter column
SQL
0 vote290 views1 answer
Sql server for loop
SQL
2 votes245 views2 answers
Function in sql
SQL