Joining a table in a views handler

I have not read your question thouroughly, but you can try it with hook_views_query_alter().

You still have to work on this, but you will get something like this:

/**
 * Implements hook_views_query_alter().
 */
function YOUR_MODULE_views_query_alter(&$view, &$query) {
  if ($view->name == 'MY_VIEW') {
    // Determine language, not sure where to find this here
    $language = SOMEWHERE_YOU_MUST_DETERMINE_LANUAGE;

    // Join your tables
    $query->join('field_data_field_blog_title', 'fbt', 'fbt.id = blog.id AND fbt.language = ' . $language);
  }
}

I dont think you should add a join there. I believe at this point your table is already joined and has an alias.

Maybe you can do something like this in ba_views_data_alter() :

    $data['j_blog']['table']['join'] = array(
        'blog' => array(
            'left_field' => 'id',
            'field' => 'id',
            'extra' => array(
                array('field' => 'language', 'value' => '***CURRENT_LANGUAGE***'),
            ),
        ),
    );

I hope this helps.

Hi, guys!

I had to do INNER JOIN in my sort handler and while searching in google I got to this thread. I used the info from comments above to compile my solution which I am gonna share in a second. On a different note, I'd like to say that achieving it via hook_views_query_alter() from my point of view is a bit inprofessional. For example in my case I am building a general purpose module that will be used in many different occasions and of course I can't forsee all possible use cases in hook_views_query_alter(). So...

$table = 'table_i_wanna_join'; // i.e. how the table is represented in drupal database schema, without prefixes.
$left_table = $this->table; // the table to which I want to join it. Mostly I assume you'll want to join it to the table of your handler
$left_field = 'left_id'; // a column in $left_table on which you wanna join
$field = 'id'; // a column in $table on which you wanna join
// We create a new join object and provide it with information about the join we wanna make.
$join = new views_join();
$join->construct($table, $left_table, $left_field, $field, array(), 'INNER');

// Now, here we've kind of compiled the relationship between 2 tables, yet we gotta throw it into the View to take effect.

$alias = 'alias_i_want_for_table'; // Alias under which you wanna see $table once it has been JOINed with all the other tables.
// $this->table_alias below exposes to view under what alias $left_table is manipulated in the SQL we are building.
// $this->relationship below is used when the view has relationships and the same table may be referred for example from the base table of view, or from one of the relationships.
$alias = $this->query->add_relationship($alias, $join, $this->table_alias, $this->relationship);
// Last note, you gotta get $alias as return of this method because the desired alias may be already occupied by some other previously joined table, so this method will kindly adjust your desired alias to some unique string based on the original value of $alias.

Above is a general case. Jaypan, as far as I got it from your post, you will need to use parameter $extra in views_join::construct() method to pass on the language restriction, and your left_field and field will be the IDs of your entities. It took me the whole evening to figure it out, so I decided it'd be worth to post it somewhere :)

class views_handler_filter_inbound_calling_filter_source extends views_handler_filter {

  function value_form(&$form, &$form_state) {
    parent::value_form($form, $form_state);
    if (!empty($form_state['exposed'])) {
      $form['value'] = array(
        '#type' => 'select',
        '#title' => t('Select Source'),
        '#options' => inbound_calling_source_options(),
      );
    }
//    else {
//      $form['value'] = array(
//        '#type' => 'hidden',
//        '#value' => $this->options['filter_default_value'],
//      );
//    }
  }

  function query() {
    $this->ensure_my_table();
    if (is_array($this->value)) {
      $value = array_filter($this->value);
    }
    else {
      $value = $this->value;
    }
    $table = 'inbound_calling_complain_source'; // The table to be joined
    $left_table = $this->table; // the table to be joined to
    $left_field = $this->real_field; // a column in $left_table on which to join
    $field = 'ibcl_hid'; // a column in $table on which to join
    // We create a new join object and provide it with information about the join
    $join = new views_join();
    $extra = array();
    $extra[] = array(
      'table' => 'alias_i_want_for_table',
      'field' => 'source',
      'value' => $value,
      'operator' => '=',
    );
    $join->construct($table, $left_table, $left_field, $field, $extra, 'INNER');
    $alias = 'alias_i_want_for_table';
    $alias = $this->query->add_relationship($alias, $join, $this->table_alias, $this->relationship);

//    $this->query->add_where(0, 'alias_i_want_for_table.source', $value, '='); 
// this where clause was working, but wanted to add the AND in the join itself to improve efficiency, so after adding the $extra, i commented it out.

  }

}