Data from several Fact Tables

upaliwije — Sun, 01 Dec 2013 06:11:34 GMT

I have following Tables

Table 1

Ref_No,Sales,Order No,Date

Table 2

Order No, Comm_Amount, Date

Table 3

Date,Order No,REF_No, Comm_code,

I have concatenate above 3 tables can obtain following output

Date,Ref_No,Order No, Comm_code,Sales,

But I can not obtain Commission amount Comm_Code wise.

Pls someone help me to obtain the correct output

Thanks

Re: Data from several Fact Tables

sasikanth — Sun, 01 Dec 2013 07:17:41 GMT

Hiii

Try to post an example so that people can give better solutions