/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 vote187 views2 answers
Suse Linux restart MySQL
SQL
0 vote143 views1 answer
Soql more than today
SQL
8 votes159 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote175 views1 answer
Arithmetic expression in sql
SQL
0 vote175 views1 answer
Mysql join only one column
SQL
2 votes142 views1 answer
Mysql how to store lat,lng
SQL
1 vote240 views1 answer
Primary key reset in SQL database
SQL
0 vote164 views1 answer
How to insert same table data using mysql query
SQL
0 vote156 views1 answer
Get date from timestamp in mysql
SQL
2 votes177 views2 answers
Python escape string for sql
SQL