/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

-2 votes195 views1 answer
Use of where in left join in mysql
SQL
0 vote187 views1 answer
Inserting data into different tables at once in oracle sql
SQL
2 votes135 views1 answer
Sql view column data type
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote245 views3 answers
Mysql keyword search
SQL
1 vote209 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote190 views1 answer
Components/Fields of Internal Table
SQL
0 vote191 views1 answer
Create database store
SQL
0 vote177 views1 answer
Mysql percentage of total
SQL
31 votes228 views2 answers
Grant all priviledges to mysql user
SQL