ติดปัญหา SUM กับ DISTINCT โดยมีเงื่อนไขตามรูปตารางรายการดังนี้ครับ

<?
	$objConnect = mssql_connect("10.1.1.18","sa","sa") or die("Error Connect to Database");
	$objDB = mssql_select_db("KHLD");
	$strSQL = "SELECT * FROM codeitem WHERE COMPANY = '430' AND ITEM = 'BSCDVAIMAR-0179' AND LOT LIKE '%4243#02%'  ";
	$objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
  <tr>
    <th div align="center">Item_no </div></th>
    <th><div align="center">Item_name </div></th>
    <th><div align="center">Item_description </div></th>
    <th><div align="center">Lot</div></th>
    <th><div align="center">Print_Qty </div></th>
  </tr>
<?
while($objResult = mssql_fetch_array($objQuery))
{
?>
<?
	$COMPANY = $objResult["COMPANY"];
	$ITEM = $objResult["ITEM"];
	$LOT = $objResult["LOT"];
	$QUANTITY = $objResult["QUANTITY"];
	
	$a1 = $objResult["BRANCH"];
	$a2 =$objResult["LMCATEGORY2"];
	$a3 =$objResult["LMCATEGORY3"];
	$a4 =$objResult["PRODUCTTYPE"];
	$a5 =$objResult["LOT"];
	$LOTNUMBER = $a1.$a2.$a3.$a4.$a5;
?>
  <tr>
    <td><?=$objResult["ITEM"];?></td>
    <td><?=$objResult["ITEMNAME"];?></td>
    <td><?=$objResult["ITEMDES"];?></td>
    <td><?=$LOTNUMBER;?></td>
    <td><?=$objResult["QUANTITY"];?></td>
  </tr>
<?
}
?>
</table>
<?
mssql_close($objConnect);
?>

SELECT ITEM,ITEMNAME,ITEMDES,BRANCH,LMCATEGORY2,........,SUM(QUANTITY) FROM codeitem  WHERE COMPANY = '430' GROUP BY ITEM