Order Table
Raw Output
To get a listing of the books, we need to use an INNER JOIN to pull in the book titles:
The raw order table (below) needs some work... See how it is done here Here is a good overview on how SQL inner inner join relates to VLOOKUP in Excel
| Order ID | Book Title | Number Ordered | Date Ordered | Date Received | Discount Price |
| 1 | 200 | 50 | 2019-11-07 | 2019-11-14 | 16.00 |
| 2 | 148 | 30 | 2019-11-07 | 2019-11-14 | 21.00 |
| 3 | 14 | 35 | 2019-11-07 | 2019-11-14 | 8.00 |
| 4 | 689 | 70 | 2019-11-08 | 2019-11-14 | 27.00 |
| 5 | 54 | 90 | 2019-11-08 | 2019-11-14 | 23.00 |
| 6 | 89 | 32 | 2019-11-09 | 19.00 | |
| 7 | 23 | 21 | 2019-11-09 | 6.00 | |
| 8 | 400 | 70 | 2019-11-10 | 31.00 | |
| 9 | 876 | 20 | 2019-11-10 | 12.00 | |
| 10 | 32 | 20 | 2019-11-10 | 25.00 |