現有品號及庫存狀態
<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>