约 2 个结果
在新选项卡中打开链接
How get different column from different table in single row
2011年1月24日 · Select Reqid,Name,Status,E.ProPNa me from ReqMaster R join ProjMaster P on R.Id=P.id join Systext S on S.sid=P.sid join ExtDef D on S.ExtId=E.ExtID this returns multiple rows for sing req id with different value for property like Reqid Name Status ProppName 1 hhhh jjj klkkj 1 hhhh jjj kjgfff 1 hhhh jjj nnnnnn but i want the result as Reqid Name Status PropName1 …
Select different columns into single row - Experts Exchange
2011年1月21日 · I think you didn't get my point. I put my query here with details. Select Reqid,Name,Status,E.ProPNa me from ReqMaster R join ProjMaster P on R.Id=P.id join Systext S on S.sid=P.sid join ExtDef D on S.ExtId=E.ExtID this returns multiple rows for sing req id with different value for property like Reqid Name Status ProppName 1 hhhh jjj klkkj 1 ...