=1)
AND (ol.OBSMCD not in('11000','30001','30002','30003','30004'))
$cond1
GROUP BY ol.OBSMCD,cm.JUTX40,ol.OBITNO,ol.OBITDS
ORDER BY ol.OBSMCD,ol.OBITNO ASC
SQL;
echo $sql;
$rs=odbc_exec($con,$sql);
$Period = $_POST["YearFrom"].$_POST["MonthFrom"];
$Channel = $_POST["CmbCh"];
?>SUMMARY
SALEMAN |
ITEMNO |
ITEMNAME |
QTY |
NETAMOUNT |
CHANNEL |
|
|
|
|
|
|
|
| TOTAL |
|
|
|
|
|