Sql

Search

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)

Comment

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql update from n to 100
Sql :: drop domain postgresql
Sql :: Question 7: Write an SQL query to print details of the Workers who have joined in Feb’2014.
Sql :: how to check current root password in mysql
Sql :: bigquery information_schema schema all columns
Sql :: sql track modification
Sql :: update from select postgresql
Sql :: Write the order of execution of all the SQL clauses and statements
Sql :: how to use select union and loop
Sql :: SQL Syntax of FULL OUTER JOIN
Sql :: sql update by id
Sql :: use of undefined constant mysql_assoc - assumed
Sql :: sql length
Sql :: mariadb used space
Sql :: sql average
Sql :: into operator in sql
Sql :: Order of execution SQL or MySql query Or Logical order of operations:
Sql :: sql convert int to string
Sql :: sql like with multiple values
Sql :: ubuntu install mysql 5.7
Sql :: create user in mysql
Sql :: clustered-nonclustered indexes(constraints)
Sql :: SQL Addition Operator
Sql :: mysql order by list
Sql :: index in mysql
Sql :: auto increment psql not primary key
Sql :: sql decimal with 2 places
Sql :: postgres jsonb array push new element
Sql :: postgres add foreign key to existing table
Sql :: SELECT statement to find the specific cell in database table

Search

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

ADD CONTENT