?

[xyz1]

.

[xyz1]

.

[prma7799]

Have you check the attachment ?

[xyz1]

.

[prma7799]

First synthetic  is because of your join keyword is not proper.

Second is in Resource Allocation table have multiple same common fields name, hence you will get two synthetic key here. so i join this MonthlyData table ....