Issue with JOIN construction generation:

SQL: select rid from redirect r join node n on n.nid = r.nid where source = 'ttt'

RESULT:

db_select('redirect', 'r')
	->fields('r', array('rid'))
	<b>->join('node', 'n', 'n.nid = r.nid')</b>
	->condition('source', 'ttt')
	->execute()

But JOIN can't be used this way: http://drupal.org/node/310075#joins