Using JOINs in the SelectCommand
| Delete | | Gates | Bill | | |
| Delete | | Bush | George | | |
| Delete | | Walther | Stephen | | |
| Delete | Sales Representative | Davolio | Nancy | | |
| Delete | Sales Representative | Leverling | Janet | | |
| Delete | Sales Representative | Peacock | Margaret | | |
| Delete | Inside Sales Coordinator | Callahan | Laura | | |
| Delete | Sales Representative | Dodsworth | Anne | Steven | Buchanan |
| Delete | Sales Manager | Buchanan | Steven | | |
| Delete | Sales Representative | Suyama | Michael | Steven | Buchanan |
| Delete | Sales Representative | King | Robert | Steven | Buchanan |