Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hiii
Try to post an example so that people can give better solutions