2,727
社区成员
发帖
与我相关
我的任务
分享
Select A.Id,A.syGongSi,
物料编码=(case when A.syGongSi = 1 then Z1.goodscode when A.syGongSi = 2 then Z2.goodscode end),
物料名称=(case when A.syGongSi = 1 then Z1.goodsname when A.syGongSi = 2 then Z2.goodsname end)
From CaiGouDingDan A
Left Join 数据库a.dbo.ba_goods Z1 On A.goodsid=Z1.goodsid
Left Join 数据库b.dbo.ba_goods Z2 On A.goodsid=Z2.goodsid