Duplicate column headers hana

On trying to create the view, I am getting error 'duplicate column name: PXX_ID'. I cannot do an inner join as most of the data in the 2 columns I am joining on don't match and I still need all of the data. Now, I understand this can be avoided by putting aliases for the column but that would make my situation difficult as I have almost 100 tables to be put into the view out of which some will have multiple matching columns and I am already using dynamic SQL to make it work

Is there any other way I can retain all columns from both tables and still save it in the view?