chapter 1 lab3/extend_janitorial_services.accdb
| Customer Number | Customer Name | Address | City | Balance | Employee Number |
| AT23 | Atlas Repair | 220 Beard St. | Kadrick | ¤ 670.25 | 203 |
| AZ01 | AZ Auto | 412 Beechwood Ave. | Carlston | ¤ 1,200.00 | 210 |
| BL35 | Blanton Shoes | 443 Chedder St. | Conradt | ¤ 786.00 | 210 |
| CJ45 | C Joe Diner | 87 Fletcher Ave. | Kadrick | ¤ 1,345.00 | 214 |
| CM90 | Cramden Co. | 234 Fairlawn Dr. | Carlston | ¤ 1,895.00 | 203 |
| HI25 | Hill Crafts | 245 Beard St. | Carlston | ¤ 0.00 | 210 |
| KL50 | Klean n Dri | 378 Stout Ave. | Kadrick | ¤ 925.00 | 210 |
| MC10 | Moss Carpet | 109 Fletcher Ave. | Conradt | ¤ 765.00 | 203 |
| PV83 | Prime Video | 734 Lanton Dr. | Conradt | ¤ 450.00 | 214 |
| SE05 | Servete Mfg Co. | 879 Redfern St. | Kadrick | ¤ 895.00 | 210 |
| Employee Number | Last Name | First Name | Hourly Rate |
| 203 | Estevez | Tammy | ¤ 12.50 |
| 210 | Hillsdale | Rachel | ¤ 12.75 |
| 214 | Liu | Chou | ¤ 12.65 |
| 220 | Short | Timmy | ¤ 12.50 |
SELECT Customer.[Customer Number], Employee.[First Name], Employee.[Last Name], Customer.Balance, Customer.[Employee Number]
FROM Employee INNER JOIN Customer ON Employee.[Employee Number] = Customer.[Employee Number];
latice1
chapter_1_lab3.rar
