array( 'left_field' => 'lid', 'field' => 'lid', ), // location_phone links to node through location_instance via lid. 'node' => array( 'left_table' => 'location_instance', 'left_field' => 'lid', 'field' => 'lid', ), // location_phone links to node_revision through location_instance via lid. 'node_revision' => array( 'left_table' => 'location_instance', 'left_field' => 'lid', 'field' => 'lid', ), // location_phone links to users through location_instance via lid. 'users' => array( 'left_table' => 'location_instance', 'left_field' => 'lid', 'field' => 'lid', ), ); // ---------------------------------------------------------------- // location_phone table -- fields $data['location_phone']['phone'] = array( 'title' => t('Phone'), 'help' => t('The phone number of the selected location.'), 'field' => array( 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_string', 'empty field name' => t('None'), ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), ); return $data; }