求看一下这个视图的问题

你先看下你查询的结果，肯定是有两列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