/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 vote159 views1 answer
Check constraint is violated
SQL
0 vote145 views1 answer
Oracle sql date summer time
SQL
0 vote141 views1 answer
Psql store procedure-return multiple table values
SQL
12 votes221 views2 answers
Find duplicates mysql column
SQL
0 vote139 views1 answer
Mysql terminal list table
SQL
8 votes161 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote169 views1 answer
Find wordpress version in database
SQL
0 vote143 views1 answer
How to login to mysql in homestead
SQL
0 vote159 views1 answer
Mysql config slave
SQL
3 votes144 views3 answers
Stop mysql ubuntu
SQL