Re: [SQL ] 如何下此sql指令

[glennchen (阿仁)]

參考一下

SELECT L.CID, C1.Name, L.EID, C2.Name

FROM Company C1, List L, Company C2

WHERE C1.CID = L.CID AND L.EID = C2.CID

--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.24.126.64
※ 編輯: glennchen       來自: 114.24.126.64        (02/13 13:06)
推 f0987654:many thanks !!  可以了，太感謝了