/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 vote275 views2 answers
Timing sql queries
SQL
6 votes254 views1 answer
Phpmyadmin reset root password
SQL
0 vote258 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote272 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
3 votes299 views3 answers
1396(hy00) mysql error
SQL
1 vote290 views1 answer
Round function in sql oracle
SQL
14 votes288 views3 answers
Trim sql
SQL
0 vote280 views1 answer
Where date in datetime mysql
SQL
19 votes279 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
16 votes289 views1 answer
Sql comment'
SQL