## 28.2 Queries (cont.)

Invoice
Invoice_Number | Customer_Number | Payment
--- | --- | ---
`INTEGER` | `INTEGER` | `DECIMAL(10,2)`
11731 | 3175 | 0
11732 | 3176 | 249.5
11733 | 3175 | 0

Customer
Customer_Number | Name | Address | City | State | Zip
--- | --- | --- | --- | --- | ---
`INTEGER` | `CHAR(40)` | `CHAR(40)` | `CHAR(30)` | `CHAR(2)` | `CHAR(10)`
3175 | Sam's Small Appliances | 100 Main St. | Anytown | CA | 98765
3176 | Electronics Unlimited | 1175 Liberty Ave. | Pleasantville | MI | 45066

prev |top |next