Fetching column data with same name from multiple tables without using alias
I have two tables with the same column name but they are not related by any primary, foreign key. They are two different columns. While using join i want the result to display both the columns with their actual names. I am getting error The column 'xx' was specified multiple times for 'yy'. I know this can be resolved by using alias names but is there any other solution where we can get the results with the actual names?
You should be able to do
SELECT x.foo, y.foo FROM x, y