title: SQL join or what?
body: <p>I'm an SQL newbie. sorry.
  i have 3 tables: services, cities, city_services. i need to get all services that are available in a given city (using city_id) from the city_services table, but also want to grab the service name from the service table - all in one statement. I know i can nest 2 statements and 2 while loops (php) but that seems inefficient.</p>
  
  <p>Do i need a JOIN or a nested sql statement? i Can't wrap my head around this.</p>
  
  <p>Any help or pointing in the right direction would be great!</p>
  
  <p>Thanks.</p>
  
  <p>sndwg</p>