SELECT a.FK_Time, a.FK_Org, b.FK_Lob, a.FK_Sub, a.FK_Store, b.FK_Types, a.FK_Category, a.FK_Class, a.FK_Property,
a.FK_Report, a.Quantity, a.Money, 1 AS FK_Customer
FROM RMS.tFactInventory AS a LEFT OUTER JOIN
RMS.tRelation AS b ON a.FK_Relation = b.PK_ID
WHERE (a.FK_Report = 7)
UNION
SELECT a.FK_Time, a.FK_Org, a.FK_Lob, a.FK_Sub, a.FK_Store, b.FK_Types, a.FK_Category, a.FK_Class, a.FK_Property,
a.FK_Report, a.Quantity, a.Money, a.FK_Customer
FROM RMS.tFactInventory AS a LEFT OUTER JOIN
RMS.tRelation AS b ON a.FK_Relation = b.PK_ID
WHERE (a.FK_Report = 8)
6 个回复
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-06-18 回答
赞同来自:
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-06-18 回答
赞同来自:
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-06-18 回答
赞同来自:
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-06-19 回答
赞同来自:
darkor2 2014-06-19 回答
赞同来自:
試試看,
xiongnanbin - BI学习者 2014-06-19 回答
赞同来自: