Mysql connect改寫計劃
importMark_mysql.php
<SQL> UPDATE
MARKTAG SET TD016=B.TD016, TC012=B.TC012
FROM MARKTAG A JOIN
(SELECT TD001,TD002,TD003,TD016,(select CASE WHEN X.UDF02 = THEN TC012 ELSE X.UDF02 END) AS TC012
FROM v_ORDER X JOIN INVMB ON TD004=INVMB.MB001 WHERE TD016<>'Y' AND MA002 LIKE 'M%' AND TD001<>'2201' OR TD016<>'Y' AND MA002 LIKE 'O%' AND TD004<>'32000001' AND TD001<>'2201')B ON A.TD001=B.TD001 AND A.TD002=B.TD002 AND A.TD003=B.TD003 </SQL>