Mysql connect改寫計劃

出自TSK WIKI
於 2016年5月11日 (三) 11:21 由 Root​(留言 | 貢獻) 所做的修訂 (新頁面: ==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...)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

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>