/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 vote344 views1 answer
Java sql timestamp now
SQL
0 vote284 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote292 views1 answer
Convert rows to string sql server
SQL
0 vote297 views1 answer
Oracle search columns in schema
SQL
0 vote307 views1 answer
Can't connect to postgresql mac os
SQL
1 vote307 views1 answer
Oracle create as select
SQL
0 vote318 views1 answer
Display all node label neo4j
SQL
0 vote299 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
21 votes305 views4 answers
Oracle add column
SQL
0 vote317 views1 answer
Store case result sql
SQL