Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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)
 
PREVIOUS NEXT
Tagged: #List #items #part #purchase #sql
ADD COMMENT
Topic
Name
6+3 =