If your question is about the tables having same column names and you want to rename them in the result set, then you should define aliases for them. Something like:
SELECT t1.Col1 AS T1_col1,
t1.Col2 AS T1_col2,
t2.Col1 AS T2_col1,
t2.Col2 AS T2_col2,
...
FROM Table1 t1 INNER JOIN Table2 t2 ON t1.PrimaryKeyCol = t2.ForeignKeyCol
...
WHERE ...