i01B_All_Associates.accdb
| ID | Firstname | Lastname | Title | Store ID |
| 10-60150 | Maria | Doralas | Sales Associate | CO19 |
| 10-60177 | Jennifer | Tham | Sales Associate | NM40 |
| 10-60192 | Tamra | Alix | Sales Manager | CO78 |
| 10-60195 | Byron | Hoese | Sales Associate | WA71 |
| 10-60198 | Kelley | Zeck | Sales Associate | WA71 |
| 10-60251 | Nello | Mallory | Sales Associate | CO20 |
| 10-60258 | Juan | Cerdaro | Sales Associate | NM73 |
| 10-60262 | Frieda | Ginsburg | Sales Associate | CO19 |
| 10-60285 | Margaret | Fitzpatrick | Sales Associate | OR86 |
| 10-60299 | Chet | Lee | Sales Associate | NM88 |
| 10-60359 | Reva | Lanter | Sales Associate | NM40 |
| 10-60375 | Elena | Montoya | Sales Associate | CO19 |
| 10-60392 | Marcus | Simmons | Sales Associate | OR86 |
| 10-60429 | Salvador | Shames | Sales Associate | OR86 |
| 10-60438 | Julette | Villanyeve | Sales Associate | NM40 |
| 10-60492 | Ellen | Gula | Sales Associate | OR86 |
| 10-60722 | Vicki | Plasek | Sales Associate | NM52 |
| 10-60736 | Brendon | Gallager | Sales Manager | OR86 |
| 10-60739 | Mara | Monell | Sales Associate | WA35 |
| 10-60781 | Dave | Demoura | Sales Associate | NM88 |
| 10-60782 | Karen | Jones | Sales Associate | NM88 |
| 10-60792 | Casey | Drees | Sales Associate | NM88 |
| 10-60822 | Vic | Fowler | Sales Associate | OR10 |
| 10-60825 | Naomi | Deford | Sales Associate | OR10 |
| 10-60826 | Jim | Wolfgang | Sales Manager | NM88 |
| 10-60911 | Adrea | Rhyn | Sales Associate | OR40 |
| 10-60924 | Emily | Rhoades | Sales Associate | CO78 |
| 10-60925 | Jerry | Chung | Sales Associate | OR40 |
| 10-60926 | Johnie | Borello | Sales Associate | NM88 |
| 10-60927 | Jake | Kettler | Sales Associate | OR10 |
| 10-60944 | Sergio | Bergan | Sales Associate | CO19 |
| 10-60966 | Issac | Boerner | Sales Associate | OR10 |
| 10-60971 | Michael | Stober | Sales Associate | OR10 |
| 10-60977 | Skylar | Weiden | Sales Associate | NM40 |
| 10-60985 | Clifton | Durfey | Sales Associate | WA35 |
| 10-60988 | Margaret | Voboril | Sales Manager | NM52 |
| 10-70115 | Heidi | Hermann | Sales Associate | NM40 |
| 10-70155 | Sandy | Elry | Sales Associate | WA35 |
| 10-70175 | Jamie | Maciejewski | Sales Associate | NM73 |
| 10-70176 | Jeff | Paolino | Sales Associate | WA35 |
| 10-70193 | Casey | Creeden | Sales Associate | NM40 |
| 10-70259 | Alejandra | Balentine | Sales Associate | NM73 |
| 10-70278 | Angelique | Edstrom | Sales Associate | WA35 |
| 10-70352 | Anita | Delgado | Sales Associate | CO19 |
| 10-70495 | Maricela | Fisler | Sales Associate | NM73 |
| 10-70529 | Fernando | Lopez | Sales Associate | OR40 |
| 10-70578 | Helga | Cowens | Sales Associate | CO20 |
| 10-70585 | Rhea | Hopkins | Sales Associate | NM88 |
| 10-70588 | Stuart | Burbage | Sales Associate | NM88 |
| 10-70625 | Lesa | Ficke | Sales Associate | OR40 |
| 10-70629 | Doretha | Glosson | Sales Associate | CO20 |
| 10-70699 | Denice | Faeth | Sales Associate | OR69 |
| 10-70762 | Rae | Gerhard | Sales Associate | NM88 |
| 10-70825 | Marquite | Amodeo | Sales Associate | OR69 |
| 10-70845 | Judi | Crowston | Sales Associate | OR40 |
| 10-70877 | Austin | Hallman | Sales Associate | OR40 |
| 10-70915 | Araceli | Saine | Sales Associate | OR69 |
| 10-70927 | Stuart | Brittan | Sales Associate | CO20 |
| 10-70955 | Fredrick | Clune | Sales Manager | WA35 |
| 10-70966 | Olivia | Perez | Sales Associate | NM73 |
| Store ID | Address | City | State |
| CO19 | 197 Tower Rd | Denver | CO |
| CO20 | 208 E Central Ave | Golden | CO |
| CO40 | 403 Starlight Blvd | Denver | CO |
| CO78 | 782 Mill Rd SW | Colorado Springs | CO |
| CO79 | 7925 S Forrest Rd | Boulder | CO |
| CO98 | 98045 North Ave | Aurora | CO |
| NM40 | 403 Central Blvd | Albuquerque | NM |
| NM52 | 52792 Greenfield | Taos | NM |
| NM73 | 7303 Spring Blvd | Santa Fe | NM |
| NM86 | 8692 Garden Blvd | Gallup | NM |
| NM88 | 8851 Skyline Blvd | Albuquerque | NM |
| OR10 | 10 East Blvd | Portland | OR |
| OR40 | 403 State Blvd | Salem | OR |
| OR69 | 692 Lilly Blvd | Springfield | OR |
| OR78 | 7825 Blue St | Portland | OR |
| OR86 | 8692 Tech Blvd | Eugene | OR |
| WA24 | 2445 Cove St | Spokane | WA |
| WA35 | 35725 Water Street | Tacoma | WA |
| WA51 | 51977 Winding Way | Seattle | WA |
| WA71 | 7108 Main St | Bellingham | WA |
SELECT [Sales Associates].[Firstname], [Sales Associates].[Lastname], [Store Location].[Address], [Store Location].[City], [Store Location].[State], [Store Location].[Store ID]
FROM [Store Location] INNER JOIN [Sales Associates] ON [Store Location].[Store ID]=[Sales Associates].[Store ID];