ERP開窗選項

出自TSK WIKI
於 2015年11月5日 (四) 21:39 由 Root​(留言 | 貢獻) 所做的修訂 (新頁面: ==程式碼== <sql> SELECT MI001,MI002,MG006,MI003 FROM ADMMI JOIN DSCMG ON MG002=MI001 AND MG005=MI002 WHERE (MI001='ACTMA' AND MI002='15') or (MI001='CMSME' AND MI002='03') or (MI0...)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

程式碼

<sql> SELECT MI001,MI002,MG006,MI003 FROM ADMMI JOIN DSCMG ON MG002=MI001 AND MG005=MI002 WHERE (MI001='ACTMA' AND MI002='15') or (MI001='CMSME' AND MI002='03') or (MI001='COPMA' AND MI002='07') or (MI001='INVMB' AND MI002='35') or (MI001='PURMA' AND MI002='06') </sql>