inner join 导致出现了重复字段，PIVOT多次指定到列

caoqingg 2011-10-20 04:18:16



SELECT plant, case when ProjectName Is Null then 'not allocated' else ProjectName end AS Project

FROM qry_user_segment INNER JOIN (qry_investtracking INNER JOIN 

investdoc_status ON qry_investtracking.IA_Request_status = investdoc_status.inv_d_status) ON 

(qry_user_segment.plant = qry_investtracking.plant) AND 

(qry_user_segment.segment = qry_investtracking.segment)

PIVOT (

SUM(Outlook2011) for

investdoc_status.inv_d_status_ap_group In ("Not started","in preparation","in approval","approved but not ordered","PO released","Assets arrived at Schaeffler")

) as p

GROUP BY plant

消息 8156，级别 16，状态 1，第 1 行
多次为 'p' 指定了列 'plant'。

可能因为表与视图与表之间的inner join 导致出现了重复字段，该怎么解决这个重复字段的原因。

...全文

488 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

-晴天 2011-10-20

打赏
举报

将重复的字段名之一取一个别名.

caoqingg 2011-10-20

打赏
举报

[Quote=引用 5 楼 fredrickhu 的回复:]

表与视图与表之间的inner join 导致出现了重复字段?

把表与视图与表之间的inner join 得到的结果给我们
[/Quote]
刚没写清楚，是重复的字段名。不好意思。

让你望见影子的墙 2011-10-20

打赏
举报

那就先做到视图中，去掉重复的列，然后再行列转换

--小F-- 2011-10-20

打赏
举报

表与视图与表之间的inner join 导致出现了重复字段?

把表与视图与表之间的inner join 得到的结果给我们

caoqingg 2011-10-20

打赏
举报

[Quote=引用 3 楼 herowang 的回复:]

qry_user_segment INNER JOIN (qry_investtracking INNER JOIN
investdoc_status ON qry_investtracking.IA_Request_status = investdoc_status.inv_d_status) ON
(qry_user_segment.plant = qry_investtrackin……
[/Quote]
我知道有重复plant列，但是该怎么解决这个重复的plant列呢？

让你望见影子的墙 2011-10-20

打赏
举报

qry_user_segment INNER JOIN (qry_investtracking INNER JOIN
investdoc_status ON qry_investtracking.IA_Request_status = investdoc_status.inv_d_status) ON
(qry_user_segment.plant = qry_investtracking.plant) AND
(qry_user_segment.segment = qry_investtracking.segment)
PIVOT (
SUM(Outlook2011) for
investdoc_status.inv_d_status_ap_group In ("Not started","in preparation","in approval","approved but not ordered","PO released","Assets arrived at Schaeffler")
) as p

有重复的plant的列

--小F-- 2011-10-20