/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 vote375 views1 answer
How to update date value in sql
SQL
0 vote356 views1 answer
Mysql regex exact match
SQL
3 votes371 views5 answers
Foreign keys
SQL
2 votes368 views2 answers
Mysql limit
SQL
10 votes351 views4 answers
Join with multiple conditions sql
SQL
0 vote365 views1 answer
Sqlite to csv statement
SQL
0 vote350 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote371 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote345 views1 answer
Update table sql multiple set
SQL
0 vote343 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL