I am facing the new problem as there is presence of synthetic key how can i solve this?
Rename that field or make the composite keys based on this keys.
A as Tab2A
You can use the qualify statement as well.
A synthetic key is not necessarily a problem. Read this blog post first: Synthetic Keys
see these, helpful for you:
What is synthetic keys? How it can be avoided?
Retrieving data ...