「2016集合線庫存準確專案」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
Root​(留言 | 貢獻)
 
(未顯示同一使用者於中間所作的 1 次修訂)
第1行: 第1行:
==現有品號及庫存狀態==
==現有品號及庫存狀態==
*<vba>
*SQL
<sql>
SELECT MB001,MB002,MB003, MB064,MB004,(SELECT CASE WHEN TA006 IS NULL THEN 'N' ELSE 'Y' END)AS TA FROM INVMB
SELECT MB001,MB002,MB003, MB064,MB004,(SELECT CASE WHEN TA006 IS NULL THEN 'N' ELSE 'Y' END)AS TA FROM INVMB
LEFT JOIN  
LEFT JOIN  
(SELECT TA006 FROM MOCTA WHERE TA013='Y' GROUP BY TA006)X ON TA006=MB001  
(SELECT TA006 FROM MOCTA WHERE TA013='Y' GROUP BY TA006)X  
WHERE MB001 LIKE '4%' AND MB031 ='' ORDER BY MB002
ON TA006=MB001  
  </vba>
WHERE MB001 LIKE '4%' AND MB031 ='' ORDER BY MB002
  </sql>

於 2016年10月13日 (四) 08:57 的最新修訂

現有品號及庫存狀態

  • SQL

<sql> SELECT MB001,MB002,MB003, MB064,MB004,(SELECT CASE WHEN TA006 IS NULL THEN 'N' ELSE 'Y' END)AS TA FROM INVMB LEFT JOIN (SELECT TA006 FROM MOCTA WHERE TA013='Y' GROUP BY TA006)X ON TA006=MB001 WHERE MB001 LIKE '4%' AND MB031 = ORDER BY MB002

</sql>