title: Why doesn't the view use the database table I defined in hook_views_data()?
body: <p>I have a problem with my module views integration. I need to provide information about user who added video and timestamp. Video field is a CCK Embedded Media Field and it stores in content_field_3d_party_video table.</p>
  <p>The schema is defined from the following code.</p>
  <pre class="lang-php prettyprint-override"><code>function MODULE_schema() {
    $schema = array();
    
    $schema['video_data'] = array(
        'description' =&gt; t('Users and timestamps for video field'),
        'fields' =&gt; array(
          'value' =&gt; array(
            'description' =&gt; t('Emfield value'),
            'type' =&gt; 'varchar',
            'length' =&gt; '255',
            'not null' =&gt; TRUE,
            'default' =&gt; '',
          ),
          'uid' =&gt; array(
            'description' =&gt; t('User id'),
            'type' =&gt; 'int',
            'unsigned' =&gt; TRUE,
            'not null' =&gt; TRUE,
            'default' =&gt; 0,
          ),
          'timestamp' =&gt; array(
            'description' =&gt; t('Timestamp'),
            'type' =&gt; 'int',
            'unsigned' =&gt; TRUE,
            'not null' =&gt; TRUE,
            'default' =&gt; 0,
          ),
        ),
        'primary key' =&gt; array('value'),
        'indexes' =&gt; array(
          'timestamp' =&gt; array('timestamp'),
          'uid' =&gt; array('uid'),
        ),
      );
    
    return $schema;
  }
  </code></pre>
  <p>The <code>hook_views_data()</code> implementation is the following.</p>
  <pre class="lang-php prettyprint-override"><code>function MODULE_views_data() {
    $data = array();
      
    $data['video_data']['table']['group'] = t('Video Data');
      
      $data['video_data']['table']['join'] = array(
          'node' =&gt; array(
              'left_table' =&gt; 'content_field_3d_party_video',
              'left_field' =&gt; 'field_3d_party_video_value',
              'field' =&gt; 'value',
          ),
          'users' =&gt; array(
              'left_field' =&gt; 'uid',
              'field' =&gt; 'uid',
          ),
      );
      
      $data['video_data']['value'] = array(
          'title' =&gt; t('Video value'),
          'relationship' =&gt; array(
              'base' =&gt; 'content_field_3d_party_video',
              'base field' =&gt; 'field_3d_party_video_value',
              'field' =&gt; 'value',
              'handler' =&gt; 'views_handler_relationship',
              'label' =&gt; t('Video value'),
          ),
      );
  
      $data['video_data']['uid'] = array(
          'title' =&gt; t('User id'),
          'relationship' =&gt; array(
              'base' =&gt; 'users',
              'base field' =&gt; 'uid',
              'field' =&gt; 'uid',
              'handler' =&gt; 'views_handler_relationship',
              'label' =&gt; t('User id'),
          ),
      );
      
      $data['video_data']['timestamp'] = array(
          'title' =&gt; t('Timestamp field'),
          'field' =&gt; array(
              'handler' =&gt; 'views_handler_field_date',
              'click sortable' =&gt; TRUE,
          ),
          'sort' =&gt; array(
              'handler' =&gt; 'views_handler_sort_date',
          ),
          'filter' =&gt; array(
              'handler' =&gt; 'views_handler_filter_date',
          ),
      );
      
      return $data;
  }
  </code></pre>
  <p>The table isn't included in the SQL query generated for the view.</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT node.nid AS nid,
     node.title AS node_title,
     node.language AS node_language,
     node_data_field_3d_party_video.field_3d_party_video_embed AS node_data_field_3d_party_video_field_3d_party_video_embed,
     node_data_field_3d_party_video.field_3d_party_video_value AS node_data_field_3d_party_video_field_3d_party_video_value,
     ...
     node.type AS node_type,
     node.vid AS node_vid
   FROM node node 
   LEFT JOIN content_field_3d_party_video content_field_3d_party_video_video_data ON value = content_field_3d_party_video_video_data.field_3d_party_video_value
   LEFT JOIN users users_video_data ON uid = users_video_data.uid
   LEFT JOIN content_field_3d_party_video node_data_field_3d_party_video ON node.vid = node_data_field_3d_party_video.vid
   WHERE ...
  </code></pre>
  <p>May you help me?</p>