//Other Database name : mydatabase.
$db_name = 'mydatabase';
$data['fieldname'] = array(
'table' => array(
 'name' => $db_name . '.fieldname',
 'group' => t('The Group'),
 'base' => array(
   'field' => 'id',
   'title' => t('The field title'),
   'help' => t('Field description'),
   'database' => $db_name,
 ),
 'join' => array(
   'users' => array(
    'table' => $db_name . '.fieldname',
    'left_field' => 'id',
    'field' => 'id2',
   ),
 ),
),
);
doesn't work for me when follwing this approach and including a relationthip in one field
'relationship' => array(
   ...
   'base'        => 'mydefaultdb' . '.users_field_data',
   'base field'     => 'uid',
   'field'        => 'uid',
  ),
Comments1
not working
doesn't work for me when follwing this approach and including a relationthip in one field
'relationship' => array(
   ...
   'base'        => 'mydefaultdb' . '.users_field_data',
   'base field'     => 'uid',
   'field'        => 'uid',
  ),
Â