Join a custom table on a View

Question

I need to join a custom table custom_table on a View my_view.

I have a module created called join_table

The nid is the referential id (the nid is what ties the two table to the view).

Then, I need to take the info the column price in custom_table and be able to display using my Views template.

I'm completely lost.

Answer 1

Example:

/**
 * Implements hook_views_api()
 * @file modulename.module
 */
function modulename_views_api() {
  return array('api' => 2);
}

/**
 * Implements hook_views_data()
 * @file modulename.views.inc
 */
function modulename_views_data() {
  $data['custom_table']['table']['join']['node'] = array(
    'left_field' => 'nid',
    'field' => 'nid',
  );

  $data['custom_table']['price'] = array(
    'title'  => 'Title',
    'help'   => 'Help',
    'group'  => t('Node'),
    'field'  => array('handler' => 'views_handler_field'),
    'sort'   => array('handler' => 'views_handler_sort'),
    'filter' => array('handler' => 'views_handler_filter_string'),
  );

  return $data;
}

Read more info in oficial manual Describing tables to Views