首頁(yè) 猿問(wèn) 關(guān)于sql語(yǔ)句一對(duì)多語(yǔ)生成一條語(yǔ)句...

關(guān)于sql語(yǔ)句一對(duì)多語(yǔ)生成一條語(yǔ)句之后，（不是簡(jiǎn)單的join表）怎么實(shí)現(xiàn)查詢

SQL Server

你胖到影響我了 2015-07-17 11:09:47

SELECT? ????T1.*, ????(SELECT???T2.PartName+','? ?????FROM?wf_work_items?T2 ?????WHERE?T1.ProcID=T2.ProcID ?????FOR?XML?PATH('') ????)?as?PartName?, ????(SELECT???T2.PartDeptName+''? ?????FROM?wf_work_items?T2 ?????WHERE?T1.ProcID=T2.ProcID ?????FOR?XML?PATH('') ????)?as?PartDeptName FROM?Con_Contract??T1我要的是T1?的主鍵??對(duì)應(yīng)?T2的PartName（多個(gè)數(shù)據(jù)對(duì)應(yīng)一一個(gè)主鍵）?和PartDeptName?但只能生成一條???如圖：現(xiàn)在我已經(jīng)查出來(lái)了???就想怎么實(shí)現(xiàn)著PartName?和?PartDeptName兩個(gè)的查詢?求解求解

查看完整描述

1 回答

你胖到影響我了

TA貢獻(xiàn)3條經(jīng)驗(yàn) 獲得超1個(gè)贊

select?*???from?(?SELECT?
????T1.BaseContractId,
????(SELECT???T2.PartName+','?
?????FROM?wf_work_items?T2
?????WHERE?T1.ProcID=T2.ProcID
?????FOR?XML?PATH('')
????)?as?PartName?,
	(SELECT???T2.PartDeptName+''?
?????FROM?wf_work_items?T2
?????WHERE?T1.ProcID=T2.ProcID
?????FOR?XML?PATH('')
????)?as?PartDeptName

FROM?Con_Contract??T1)?T1??where?T1.PartName?like?'%王%'?and?T1.PartDeptName?like?'%道%'

已經(jīng)自己搞定~~~

1 反對(duì) 回復(fù) 2015-07-17