db_select joins in Drupal 7

Drupal 7 has an abstraction layer that standardizes database queries regardless of the underlying database on which the site is running. Although it's tempting to use db_query()  (a query function that bypasses this abstraction layer), doing so will tie you to the database platform for which the db_query query is written.