Tables
Table 1: Orders
OrderID |
CustomerID |
EmployeeID |
OrderDate |
ShipperID |
10308 |
2 |
7 |
1996-09-18 |
3 |
10309 |
37 |
3 |
1996-09-19 |
1 |
10310 |
77 |
8 |
1996-09-20 |
2 |
10365 |
3 |
3 |
1996-11-27 |
2 |
Note: There is no order in which the CustomerID = 1 (Alfreds Futterkiste).
Table 2: Customers
CustomerID |
CustomerName |
ContactName |
Address |
City |
PostalCode |
Country |
1 |
Alfreds Futterkiste |
Maria Anders |
Obere Str. 57 |
Berlin |
12209 |
Germany |
2 |
Ana Trujillo Emparedados y helados |
Ana Trujillo |
Avda. de la Constitución 2222 |
México D.F. |
05021 |
Mexico |
3 |
Antonio Moreno Taquería |
Antonio Moreno |
Mataderos 2312 |
México D.F. |
05023 |
Mexico |
37 |
Hungry Owl All-Night Grocers |
Patricia McKenna |
8 Johnstown Road |
Cork |
|
Ireland |
77 |
The Big Cheese |
Liz Nixon |
89 Jefferson Way Suite 2 |
Portland |
97201 |
USA |
Query
If you need a place to try this query, try here: https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in
SELECT Orders.OrderID, Customers.CustomerName, Customers.ContactName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID WHERE Orders.OrderId IN (10308, 10309, 10310, 10365) ORDER BY Orders.OrderId
Result
OrderID |
CustomerName |
ContactName |
OrderDate |
10308 |
Ana Trujillo Emparedados y helados |
Ana Trujillo |
1996-09-18 |
10309 |
Hungry Owl All-Night Grocers |
Patricia McKenna |
1996-09-19 |
10310 |
The Big Cheese |
Liz Nixon |
1996-09-20 |
10365 |
Antonio Moreno Taquería |
Antonio Moreno |
1996-11-27 |
© 2019, Alejandro G. Carlstein Ramos Mejia. All rights reserved.