title: how to alter a Query and join with another table in views 3.0 drupal 7.x?
body: <p>I want to alter a view and join it with taxonomy_index table but it seems that this code does not work</p>
  
  <pre><code>function MY_MODULE_views_query_alter(&amp;$view, &amp;$query) {
  $view-&gt;query-&gt;add_relationship('my_join', new views_join('taxonomy_index', 'nid', 'node', 'nid','INNER'), 'taxonomy_index');
  $view-&gt;query-&gt;add_where('country_price', "my_join.tid IN ", '2,3');
  }
  </code></pre>
  
  <p>how can I join this view's query with the taxonomy_index table?</p>