/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

10 votes329 views2 answers
Mysql select timestamp group by day
SQL
2 votes349 views1 answer
Update trigger
SQL
0 vote353 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote408 views1 answer
Drop a view in sqlite
SQL
2 votes328 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote350 views1 answer
Sp in sql server
SQL
8 votes413 views2 answers
Default sql server port
SQL
0 vote366 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote395 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote307 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL