「2016集合線庫存準確專案」:修訂間差異
跳至導覽
跳至搜尋
| 第1行: | 第1行: | ||
==現有品號及庫存狀態== | ==現有品號及庫存狀態== | ||
*< | *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 ON TA006=MB001 | ||
WHERE MB001 LIKE '4%' AND MB031 ='' ORDER BY MB002 | 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>