Hi
I have 2 fact tables. Now I want to write 2 SQLS for the 2 facts joined by UNION.
e.g.
(
SELECT D1.A1, D2.A2, 0, 0, sum(F1.A1), sum(F1.A2)
FROM D1, D2, F1
WHERE ........
GROUP BY D1.A1, D2.A2
UNION
SELECT D1.A1, D2.A2, sum(F2.A1), sum(F1.A2), 0, 0
FROM D1, D2, F2
WHERE ........
GROUP BY D1.A1, D2.A2
)
As u can see, objective is to get 2 values from 2 different fact tables in the same row.
Any solutions??
Thanks
I have 2 fact tables. Now I want to write 2 SQLS for the 2 facts joined by UNION.
e.g.
(
SELECT D1.A1, D2.A2, 0, 0, sum(F1.A1), sum(F1.A2)
FROM D1, D2, F1
WHERE ........
GROUP BY D1.A1, D2.A2
UNION
SELECT D1.A1, D2.A2, sum(F2.A1), sum(F1.A2), 0, 0
FROM D1, D2, F2
WHERE ........
GROUP BY D1.A1, D2.A2
)
As u can see, objective is to get 2 values from 2 different fact tables in the same row.
Any solutions??
Thanks