/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 votes205 views1 answer
Mysql iif
SQL
1 vote203 views1 answer
Access the postgres psql
SQL
0 vote213 views1 answer
Mysql dump for selected row
SQL
0 vote203 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
4 votes208 views1 answer
Conda install sqlalchemy
SQL
1 vote197 views1 answer
Show table status command in mysql
SQL
1 vote208 views1 answer
Error code 1175 mysql fix
SQL
0 vote195 views1 answer
Drop specific row postgresql
SQL
0 vote224 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote213 views1 answer
Copy Table from SQL to CSV
SQL