highway_patro_for_aign_9_l_2.accdb
| Citation_Num | Citation_Date | Citation_Time | Offense | Badger_Num | License_Num | Driver_License_Num |
| 1 | 11/30/14 | 12/30/99 | Speeding1 | 111 | 2RDF2091 | A12345 |
| 2 | 11/30/14 | 12/30/99 | Reckless Driving | 222 | 1FDS6739 | A21342 |
| 3 | 11/30/14 | 12/30/99 | Illegal Turn | 333 | DRBIKE | A49006 |
| 4 | 11/30/14 | 12/30/99 | Failure to Stop | 888 | 2XCC5013 | A62998 |
| 5 | 11/30/14 | 12/30/99 | Speeding1 | 111 | 2VYM1123 | A43657 |
| 6 | 11/30/14 | 12/30/99 | Speeding2 | 111 | 3TYU4456 | A70756 |
| 7 | 11/30/14 | 12/30/99 | Reckless Driving | 333 | 3LOP6522 | A56709 |
| 8 | 11/30/14 | 12/30/99 | Cell Phone Use | 555 | 1KLJ8521 | A60428 |
| 9 | 11/30/14 | 12/30/99 | Speeding1 | 111 | 2BNM9632 | A50332 |
| 10 | 11/30/14 | 12/30/99 | Speeding2 | 444 | BEEPBEEP | A11111 |
| 11 | 11/30/14 | 12/30/99 | Speeding1 | 444 | ACME | A22222 |
| 12 | 11/30/14 | 12/30/99 | Speeding1 | 222 | MYVette | A29087 |
| 13 | 11/30/14 | 12/30/99 | Speeding1 | 222 | SPEEDI | A50670 |
| 14 | 11/30/14 | 12/30/99 | Cell Phone Use | 888 | 4KKJ2233 | A33721 |
| 15 | 11/30/14 | 12/30/99 | Reckless Driving | 555 | 2BVC8797 | A37222 |
| 16 | 11/30/14 | 12/30/99 | Reckless Driving | 222 | 2RDF2091 | A12345 |
| Driver_License_Num | Driver_Name |
| A09342 | Miller |
| A11111 | Roadrunner |
| A12345 | Corbin |
| A19829 | Able |
| A21342 | Gerhart |
| A22222 | Coyote |
| A29087 | Zhu |
| A33721 | Ronville |
| A37222 | Jones |
| A43657 | Cross |
| A49006 | Little |
| A50332 | Zeno |
| A50670 | Joseph |
| a56709 | Barr |
| A60428 | Dale |
| A62998 | Small |
| A70756 | Vega |
| Offense | Amount |
| Cell Phone Use | ¤ 148.00 |
| Failure to Stop | ¤ 436.00 |
| Illegal Turn | ¤ 436.00 |
| Reckless Driving | ¤ 796.00 |
| Registration | ¤ 256.00 |
| Seatbelt | ¤ 148.00 |
| Speeding1 | ¤ 214.00 |
| Speeding2 | ¤ 328.00 |
| Badge_Num | Officer_Name |
| 111 | Jones |
| 222 | Allen |
| 333 | Makel |
| 444 | Jones |
| 555 | Thompson |
| 666 | Smith |
| 777 | Barker |
| 888 | Cruse |
| License_Num | Model | Manufacturer | Year_of_Car |
| 1FDS6739 | SUV | Volvo | 2011 |
| 1KLJ8521 | Tauras | Ford | 2012 |
| 2BNM9632 | Jetta | VW | 2009 |
| 2BVC8797 | Truck | Ford | 2007 |
| 2JIL9632 | Malibu | Chevy | 2007 |
| 2RDF2091 | Hatchback | Toyota | 2009 |
| 2VYM1123 | Expedition | Ford | 2010 |
| 2XCC5013 | Focus | Ford | 2012 |
| 3BUM1111 | Mustang | Ford | 2009 |
| 3JMN5466 | Escort | Ford | 2005 |
| 3LOP6522 | Mustang | Ford | 2009 |
| 3TYU4456 | Camero | Chevy | 2113 |
| 4KKJ2233 | Bug | VW | 2011 |
| ACME | Anvil | Acme | 1989 |
| BEEPBEEP | Roadrunner | Dodge | 1990 |
| DRBIKE | Van | Chevy | 1984 |
| MYVETTE | Corvette | Chevy | 1967 |
| SPEEDI | Corvette | Chevy | 1963 |
SELECT Citation.Citation_Num, Citation.Offense, Fine.Amount
FROM Vehicle INNER JOIN (Officer INNER JOIN (Fine INNER JOIN (Driver INNER JOIN Citation ON Driver.Driver_License_Num = Citation.Driver_License_Num) ON Fine.Offense = Citation.Offense) ON Officer.Badge_Num = Citation.Badger_Num) ON Vehicle.License_Num = Citation.License_Num;
jalqattan
