Our web developer has left our business, and we need to make a small amendment to our SQL-based website, only I don’t really know SQL. Here is what tables we have, and what we need to output. What would be the SQL query we need?
Table ‘order’:
Order ID Linecount Status
1234 3 OK
1235 1 Unpaid
1236 2 In Progress
Table ‘orderline’:
OrderlineID Order ID Value
525 1234 94
526 1234 16
527 1234 37
528 1235 762
529 1236 124
530 1236 432
Required Output:
Order ID Orderline Status Value
1234 1 OK 94
1234 2 OK 16
1234 3 OK 37
1235 1 Unpaid 762
1236 1 In Progress 124
1236 2 In Progress 432
