/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

7 votes130 views4 answers
How to reset the identity column in sql server
SQL
1 vote113 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote99 views1 answer
Query for maximum salary
SQL
11 votes140 views2 answers
How to import mysql database command line
SQL
4 votes121 views1 answer
Mysql insert from local csv
SQL
0 vote129 views1 answer
Sql change date format
SQL
0 vote140 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote126 views1 answer
Sql join on a subquery
SQL
0 vote149 views1 answer
Space not removing from column in sql
SQL
0 vote137 views2 answers
Sql server set default value equal to auto increment
SQL