'nid', ); // Note: No joins need to be made from $data['analysis']['table'] // Join the chado analysis table to analysis $data['chado_analysis']['table']['join']['analysis'] = array( 'left_field' => 'analysis_id', 'field' => 'analysis_id', ); // Join the node table to chado analysis $data['node']['table']['join']['chado_analysis'] = array( 'left_field' => 'nid', 'field' => 'nid', ); // Join the node table to analysis $data['node']['table']['join']['analysis'] = array( 'left_table' => 'chado_analysis', 'left_field' => 'nid', 'field' => 'nid', ); return $data; }