/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 vote313 views1 answer
Sql delimiter to columns
SQL
0 vote309 views1 answer
How to alter length character varying postgres
SQL
0 vote316 views1 answer
Sql server rtrim everything after character
SQL
7 votes309 views2 answers
Oracle foreign key reference table
SQL
0 vote351 views1 answer
Postgres docs /copy metacomand
SQL
0 vote279 views1 answer
Format the money fied with comma in international system using sql
SQL
1 vote321 views1 answer
Epoch time converter in snowflake
SQL
6 votes305 views1 answer
T-sql test if table exists
SQL
2 votes323 views2 answers
Get all tables using like
SQL
1 vote294 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL