The following table shows the
assigned Query:
"find the Date and Invoice Number for all invoices that were recorded for the
employee with employee id number 3."
|
Invoice Number |
Invoice Date |
Employee ID |
| 9 | 3/22/2001 | 3 |
| 5 | 2/23/2000 | 3 |
| 4 | 1/12/2000 | 3 |
(The table below is taken directly from Access)
| InvoiceNumber | InvoiceDate | EmployeeID |
|---|---|---|
| 9 | 3/22/2001 | 3 |
| 5 | 2/23/2000 | 3 |
| 4 | 1/12/2000 | 3 |
