max

 $cmdNegHist = new MySqlCommand("
			  select n.ngt_code as ngtCode, n.ngt_buyer_usr_code as uidBuyerNeg
			  from negotiation as n, user as u 
			  WHERE 
			  u.usr_email=n.ngt_buyer_usr_code
			  AND u.usr_off_code='".$office."'
			  ", $this->Connection);
				
				
				  $dreadNegHist = $cmdNegHist->ExecuteReader();
				
				  while($dreadNegHist->Read())
					{
					
							$neg_code = $dreadNegHist->ReadRow("ngtCode");
							$uidBuyer = $dreadNegHist->ReadRow("uidBuyerNeg");
							
							/*echo 'Neg Code '.$neg_code.'<br/>';
							echo 'uid Buyer '.$uidBuyer.'<br/>';*/
						//echo $neg_code.'<br/>';
							$sql="SELECT m.mnf_name as mnfName, n.ngt_start_date as negStartDate, principal.ELDIAMAXIMO as maximo00, principal.LANOTAMAXIMA as nota00, n.ngt_status as ngtStatus , n.ngt_buyer_usr_code as ngtBuyer, n.ngt_code as ngtCode
								FROM negotiation as n, manufacturer as m, user as u, 
							(
								SELECT MAIN1.diaMax as ELDIAMAXIMO, MAIN1.notes as LANOTAMAXIMA FROM 
								(
								select h.hst_date as diaMax,  h.hst_note as notes from history as h 
								WHERE  h.hst_ngt_code ='".$neg_code."' ".$autLvl."
								UNION
								select e.eml_date as diaMax, e.eml_subject as notes from email as e WHERE e.eml_ngt_code='".$neg_code."'
								) as MAIN1
								WHERE diaMax=(
										select MAX(SUBMAIN.diaMax2) FROM 
												(
												select h.hst_date as diaMax2 from history as h 
												WHERE  h.hst_ngt_code ='".$neg_code."' ".$autLvl."
												UNION
												select e.eml_date as diaMax2 from email as e WHERE e.eml_ngt_code='".$neg_code."'
												) as SUBMAIN
								
										) 
							)
							as principal
							
							WHERE n.ngt_mnf_code= m.mnf_code AND n.ngt_buyer_usr_code=u.usr_email
									AND n.ngt_status != 'ASG'
									AND u.usr_type='B'
									AND n.ngt_code='".$neg_code."'
									ORDER BY m.mnf_name
							";	
							
							
							
							
							 $cmdNegHist2 = new MySqlCommand($sql, $this->Connection);
							 $dreadDetails2 = $cmdNegHist2->ExecuteReader();