哈士奇大哥居然來了,O(∩_∩)O哈哈~謝謝哈士奇大哥了。
這個基本原因我已經找到了。是我建立FactInventory表的SQL出了問題。
大哥幫我看下我的sql吧。這下面兩個sql居然查出來的數據不一樣。
sql 1:
select * from (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)
) t
where t.FK_Time ='2014-06-10' and t.FK_Report=7
查詢出7945.
sql 2:
select * from (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)
) t
where t.FK_Time ='2014-06-10' and t.FK_Report=7
查詢出來的數據13913,居然多了。。。 這個不應該是一樣多的嗎?
[/quote]
这两个怎么可能一样呢?你用union,你卡看是不是union下面的那条语句上面那条语句有维度一样但是度量数据不一样的,可以说是负数,用union之后你就把上面一部分数据冲销掉了。
哈士奇大哥居然來了,O(∩_∩)O哈哈~謝謝哈士奇大哥了。
這個基本原因我已經找到了。是我建立FactInventory表的SQL出了問題。
大哥幫我看下我的sql吧。這下面兩個sql居然查出來的數據不一樣。
sql 1:
select * from (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)
) t
where t.FK_Time ='2014-06-10' and t.FK_Report=7
查詢出7945.
sql 2:
select * from (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)
) t
where t.FK_Time ='2014-06-10' and t.FK_Report=7
查詢出來的數據13913,居然多了。。。 這個不應該是一樣多的嗎?