大同料號變更

出自TSK WIKI
於 2016年12月20日 (二) 10:00 由 Root​(留言 | 貢獻) 所做的修訂 (新頁面: ==程式碼== <sql> SELECT A1,A2,B2,MB003 FROM (SELECT RTRIM(A1) AS A1,A2,B2 FROM (SELECT TD004 AS A1,TD005 AS A2 FROM (SELECT TD004,TD005, row_number()over(partition by TD004 ORDE...)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

程式碼

<sql> SELECT A1,A2,B2,MB003 FROM (SELECT RTRIM(A1) AS A1,A2,B2 FROM (SELECT TD004 AS A1,TD005 AS A2 FROM (SELECT TD004,TD005, row_number()over(partition by TD004 ORDER BY TD002 DESC ) AS NUM FROM COPTD WHERE TD021='Y' AND TD005 LIKE '0197-%' AND TD005 NOT LIKE '0197-U%')X1 WHERE NUM='1' GROUP BY TD004,TD005)X JOIN (SELECT TD004 AS B1,TD005 AS B2 FROM COPTD WHERE TD021='Y' AND TD005 LIKE '0197-U%' GROUP BY TD004,TD005) Y ON A1=B1)Z JOIN INVMB ON MB001=A1 </sql>