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

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: ==現有品號及庫存狀態== *<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...
 
Root​(留言 | 貢獻)
第1行: 第1行:
==現有品號及庫存狀態==
==現有品號及庫存狀態==
*<sql>SELECT MB001,MB002,MB003, MB064,MB004,(SELECT CASE WHEN TA006 IS NULL THEN 'N' ELSE 'Y' END)AS TA FROM INVMB  
*<sql>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 ON TA006=MB001  
WHERE MB001 LIKE '4%' AND MB031 ='' ORDER BY MB002
WHERE MB001 LIKE '4%' AND MB031 ='' ORDER BY MB002
</sql>
</sql>

於 2016年10月13日 (四) 08:55 的修訂

現有品號及庫存狀態

  • <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>