/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

8 votes474 views3 answers
Find table for column name in sql
SQL
0 vote333 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote413 views1 answer
Disable database droping sql
SQL
1 vote378 views1 answer
Postgresql not in
SQL
1 vote369 views1 answer
Retrieve meaning
SQL
0 vote369 views1 answer
Postgresql concat string with separator
SQL
0 vote413 views1 answer
Postgres foreign key multiple columns
SQL
0 vote351 views2 answers
How to start postgresql laravel
SQL
23 votes372 views3 answers
Sql where contains part of string
SQL
3 votes355 views1 answer
Oracle function
SQL