Hi All,
I have Three Tables all will be the same field names so I did the association.
Table1 Table2 Table3
Country Amount Country Amount Country Amount
India 4567 India 3456 India 5678
US 3456 US 12345 US 3456
Germany 1234 Germany 56789 Germany 1234
UK 4678 UK 432567 UK 789
Australia 5678 Australia 789 Australia 6789
I want to show the out put in the below format Please advise
Country table1 Amount table2 Amount table3 Amount
India 4567 3456 5678
US 3456 12345 3456
Germany 1234 56789 1234
UK 4678 432567 789
Australia 5678 789 6789