I am trying to join two tables on the same database, db2. I am trying to join tablename to tablename2 using the condition tablename.ItemID = tablename2.ItemID. While the values from tablename are selectable from a view, those from tablename2 aren’t.

Do I need to specify in what database tablename2 is?

/**  * Implementation of hook_views_data */  function  mydatabase_views_views_data() {   $data['tablename']['table']['group'] = t('Title name');   $data['tablename']['table']['base'] = array(     'field' => 'ItemID',     'title' => t('db2'),     'help' => t('Autoincremented ID field, to enable views integration'),     'database' => 'db2',     'weight' => -10,   );    $data['tablename']['table']['join'] = array(     'deals_addon' => array(       'left_field' => 'ItemID',       'field' => 'ItemID',     ),   );    $data['tablename']['ItemID'] = array(     'title' => t('Item ID'),     'help' => t('Item ID'),     'field' => array(       'handler' => 'views_handler_field',       'click sortable' => TRUE,     ),     'sort' => array(       'handler' => 'views_handler_sort',     ),     'filter' => array(       'handler' => 'views_handler_filter_string',     ),     'argument' => array(       'handler' => 'views_handler_argument_string',     ),   );    $data['tablename']['ItemInfo'] = array(     'title' => t('Item Info'),     'help' => t('Item Info'),     'relationship' => array(       'base' => 'tablename2',       'base_field' => 'ItemID',       'handler' => 'views_handler_relationship',       'label' => t('Label'),       'title' => t('Title'),       'help' => t('Help'),     ),   );   return $data;   }