SELECT result with table names for columns
===

A quick question:

Is it possible to get a MySQL result, with the tablename in front of the column instead of only the column name, when using `*`?

instead of:

`column1, column2,` etc

i would need:

`table_name.column1, table_name.column2,` etc

My problem is, that I join multiple tables togheter, that have columns with the same name (for example, `key`) but the result of the `SELECT` will only show one. And typing down every single column, in every joined table, would be a lot more work than simply using `*` and later get the result with Tablenames.

Is there any solution to this?

Thanks for the help.