Data from several Fact Tables

[upaliwije]

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

[sasikanth]

Hiii

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