สอบถาม คำสั่ง sql ต้องการ update ข้อมูลจากตารางอื่น แต่ติดปัญหาตารางที่นำมานั้นมีมากกว่า 1 แถว

update part_onhand set dateadd = (select  loandate from part_movement where item_auto=part_onhand.item_auto limit 1 order by loandate asc)

$host="localhost";
     $user="root";
     $pwd="root";
     $dbname = "unit_control";
     $link = mysql_connect($host,$user,$pwd);
     if (!$link)
	{
	   echo "<h3>Can not connect to Database</h3>";
	   exit();
	}
    mysql_select_db($dbname);
    mysql_query("SET NAMES UTF8");
    
	 $sel=mysql_query("SELECT item_auto FROM part_onhand");
    while($rs=mysql_fetch_array($sel)){
    	 
    	for($i=0;$i<count($rs["item_auto"]);$i++){
    					$item = $rs["item_auto"];
    		 $sql ="SELECT loandate FROM part_movement WHERE item_auto ='".$item."' ORDER BY loandate ASC LIMIT 1";
    		$re  = mysql_query($sql);
    		$ros  = mysql_fetch_array($re);
    		$loandate = $ros['loandate'];
    		
    		
    		 $sql_update	="update part_onhand set dateadd ='".$loandate."' WHERE item_auto ='".$item."' ";
    		mysql_query($sql_update);
    		 }
    	
    }

update Part_onhand p
inner join (select item_auto, min(loandate) min_date from Part_movement group by item_auto) as tmp
on p.item_auto = tmp.item_auto
set p.dateadd = tmp.min_date
where 1