Does anyone know if there is a way in MySQL to have it return the column names qualified with the table name? For example, suppose I have the query,
SELECT * FROM Items, Sales;
and the tables Items and Sales both only contain columns named ID and Count. By default, MySQL just adds a one to the duplicated names(in this example it would return a table with fields ID, Count, ID1, Count).
Instead of this, I want it to return the new table with the columns named as Items.ID, Items.Count, Sales.ID, Sales.Count, without me having to specify individually what to rename each column. Is this possible?
Thanks very much for any help.