I'm a beginner and just wanted to ask a basic question.
I have two tables
in my procedure I'm joining these two table and storing in variable.
I'm getting Duplicate attribute name error.
I assume this is because I had skill and level as common name in both tables.
After changing the column names in Bonus table to B_SKILL and B_LEVEL, issue was resolved.
But I believe there has to be a better way to fix this because changing the column name will not be feasible every time.