常用SQL程式碼
跳至導覽
跳至搜尋
依訂單號搜文件編號
<SQL> SELECT TA001,TA002,TD001,TD002,TD003,TD041,TD004,TD005,TD006,MB029 FROM COPTD JOIN MOCTA ON TA001='5102' AND TA002=TD054 JOIN INVMB ON TD004=MB001 JOIN COPTC ON TC001=TD001 AND TC002=TD002 WHERE TD001=2202 AND (TD002=180723022 OR TD002=180723020 OR TD002=180723019 OR TD002=180723007 OR TD002=180720017) ORDER BY TA002 </SQL>