rlz87tm45t的部落格

標題:

• 關於...FINAL FANTASY Versus XIII@1@
• 點解世界上沒有一張紙可對折超過9次-@1@
• 韓國係米有個組合叫SAM架---

 

此文章來自奇摩知識+如有不便請留言告知

SQL Script 問題...好頭痛

發問:

而家有個caseSupplier ID Supplier Name Supplier_LINK001 ABC aa>bb>cc001 ABC dd>ee>ffSuppleir.Supplier-ID = Supplier_LINK.Supplier_id咁而家我想join埋一起變成一個recordSupplier... 顯示更多 而家有個case Supplier ID Supplier Name Supplier_LINK 001 ABC aa>bb>cc 001 ABC dd>ee>ff Suppleir.Supplier-ID = Supplier_LINK.Supplier_id 咁而家我想join埋一起變成一個record Supplier ID Supplier Name Supplier_LINK 001 ABC aa>bb>cc>dd>ee>ff 個script應該點寫呢 10 pts Give to u

最佳解答:

SELECT A.SupplierID, A.SupplierName, A.Supplier_LINK + '>' + B.Supplier_LINK FROM Supplier A, Supplier B WHERE A.SupplierID = B.SupplierID AND A.Supplier_LINK <> B.Supplier_LINK

其他解答: