scottwainstock
commented
11 years ago SQL> select r.name as region_name, l.name as location_name, m.name as machine_name, m.id as machine_id from location_machine_xrefs x inner join locations l on (l.id = x.location_id) inner join machines m on (m.id = x.machine_id) inner join regions r on (l.region_id = r.id) where machine_id in (1406, 773, 709); +-----------------------------------------------------------------------------------------------+ | region_name | location_name | machine_name | machine_id | +-----------------------------------------------------------------------------------------------+ | portland | KC's Midway Bar & Grill | Harley Davidson | 709 | | portland | Black Cat | Harley Davidson | 709 | | boston | Bowl-O-Mat Inc | Harley Davidson | 709 | | chicago | Sidekick's | Harley Davidson | 709 | | colorado | Smiley's Dry Cleaners | Harley Davidson | 709 | | colorado | Gunther Toody's (Colorado Springs) | Harley Davidson | 709 | | colorado | Sufferin Bastard Tavern | Harley Davidson | 709 | | colorado | Yukon Tavern | Harley Davidson | 709 | | dfw | July Alley | Harley Davidson | 709 | | boston | Charlton Service Plaza | Harley Davidson | 709 | | portland | Fantasy for Adults Only | Harley Davidson | 709 | | chicago | Empty Bottle | Harley Davidson | 709 | | champaign | Main Street Amusements | Harley-Davidson (3rd Edition) | 1406 | | champaign | The Office II | Harley Davidson (Sega) | 773 | | cleveland | Capp's Pizza | Harley Davidson | 709 | | nyc | Gameworld Arcade | Harley Davidson (Sega) | 773 | | portland | Rialto Poolroom Bar & Cafe | Harley Davidson | 709 | | nyc | Lucky Dog | Harley Davidson | 709 | | albuquerque | Sneakerz Sports Bar | Harley Davidson | 709 | | albuquerque | Lucky's Lounge | Harley Davidson | 709 | | iowa | Shakespeare's Pub & Grill | Harley Davidson | 709 | | chicago | Big Basin Marina & Mugz's Hideout | Harley Davidson | 709 | | bayarea | Powerhouse | Harley Davidson (Sega) | 773 | | stlouis | CP Pinball | Harley Davidson | 709 | | spokane | Viking Tavern The | Harley Davidson (Sega) | 773 | | champaign | Country Tyme Lanes | Harley Davidson (Sega) | 773 | | la | Wagon Wheel Bowl | Harley Davidson | 709 | | champaign | Track Shack | Harley Davidson (Sega) | 773 | | spokane | The Falls Club | Harley Davidson (Sega) | 773 | +-----------------------------------------------------------------------------------------------+
Can you tell me which locations have these three machines?
1406 773 709