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?

Answers


You should be able to do

SELECT x.foo, y.foo FROM x, y

Need Your Help

'break' in an 'if' statement

python for-loop if-statement break

I am taking the Python course on Codeacademy.com. I am totally new to programming. We are designing a small version of the game 'Battleship' and everyone in the forums seems to be stuck on the same...

Scraping a website with cURL request not reading the HTML code

php web-crawler

Crawling http://www.mfinante.ro/infocodfiscal.html?cod=299 is not working.