求看一下这个视图的问题
你先看下你查询的结果，肯定是有两列sdorgid，这是因为你* 没有指定查哪个表的所有列
改成下面的试试：
alter view [dbo].[ord_shopbestgoodsdoc_v] as select os.descri,os.OperatorsCategory,a.*,'URP32' as Source from DB01.dbo.ord_shopbestgoodsdoc a LEFT JOIN oSDOrg os ON a.sdorgid=os.SDOrgID union select os.descri,os.OperatorsCategory,a.*,'URP32' as Source from DB02.dbo.ord_shopbestgoodsdoc a LEFT JOIN oSDOrg os ON a.sdorgid=os.SDOrgID
