Someone

function companysearch_companypage () {
  $header = array('Ticker', 'Company', 'Sector', 'Industry');
	$name = '%'.urldecode(arg(1)).'%';
	$results = db_query("SELECT a.nid, a.title, b.field_ticker_value, d.tid, d.name FROM {node} a LEFT JOIN {node_content_company} b ON a.nid = b.nid 
	   LEFT JOIN {term_node} c ON c.nid = b.nid LEFT JOIN {term_data} d ON d.tid = c.tid WHERE a.type = 'content_company' 
		AND title LIKE '%s' ORDER BY a.title", $name);
    
	  $sect = db_fetch_object(db_query("SELECT a.title, d.tid, d.name FROM {node} a LEFT JOIN {term_node} b ON b.nid = a.nid LEFT JOIN {term_hierarchy} c ON c.tid = b.tid 
	   LEFT JOIN {term_data} d ON d.tid = c.parent WHERE a.type = 'content_company' 
		AND title LIKE '%s' ORDER BY a.title", $name));  
		
	$rows = array();
	while ( $data = db_fetch_object($results)){
	  $rows[] = array(l($data->field_ticker_value, "node/$data->nid", array('title' => t('Company info')), NULL, NULL, FALSE, FALSE),	$data->title, l($sect->name, 'taxonomy/term/'.$sect->tid, NULL, NULL, FALSE, FALSE), l($data->name, 'taxonomy/term/'.$data->tid, NULL, NULL, FALSE, FALSE));
  }
	$output = theme('table', $header, $rows, array('border' => '3', 'align' => 'center'));

	return ($output);
}