would it affect a left join if you had two tables joined together with two column names that were the same?
like
select column.table1, column.table2 from table1, table2 where column.table1 = column.table2
this is a left join by default, and it will do this with no problems
