Cacher is the code snippet organizer for pro developers

JOIN 
->join($table, $alias = NULL, $condition = NULL, $arguments = array()) 
$table The table to join with. 
$alias Table alias. 
$condition Join conditions. 
$arguments Assoc array of placeholders and placeholder values. 
return Unique table alias. 
$query = db_select('users', 'u'); 
$query->innerJoin('node', 'n', 'n.uid = u.uid');
 $query->addField('u', 'name'); 
$query->addField('n', 'title'); 
$result = $query->execute(); 

->innerJoin ($table, $alias = NULL, $condition = NULL, $arguments = array()) 

->leftJoin ($table, $alias = NULL, $condition = NULL, $arguments = array())
 
->rightJoin ($table, $alias = NULL, $condition = NULL, $arguments = array())