/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 vote156 views1 answer
Get the previous column of a table in mysql
SQL
0 vote149 views1 answer
Oracle gather table statistics
SQL
0 vote174 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote157 views1 answer
Sqlite referential integrity
SQL
5 votes145 views1 answer
Sqlite alter table add column
SQL
0 vote162 views1 answer
Kill slow queries mysql
SQL
0 vote156 views1 answer
Sql row number in result set
SQL
0 vote158 views1 answer
Test the postgresql db connection
SQL
0 vote157 views1 answer
Mysql command prompt date insert format
SQL
5 votes153 views3 answers
Postgres show databases
SQL