Yes.
You can add on SELECT syntax the AS operation, like this:
SELECT
ads.id AS 'ads.id',
track.id AS 'track.id'
FROM .
-Original Message-
From: Ryan Stille [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 2:42 PM
To: mysql@lists.mysql.com
Subject: Want
Ryan Stille [EMAIL PROTECTED] wrote on 03/02/2006 12:42:01 PM:
I am working with an existing compilcated query someone wrote years ago.
When I dump the data from the query to try to figure out why I'm getting
unexpected data, I have three fields named id. Is there anyway to
tell mysql to
I don't understand what you want. If you have the original query, it should
be apparent from it where each 'id' column originated. If you're not sure
how to read the query, post it and we can help you figure out which table
provided each 'id' column.
--
Rhino
- Original Message -
The query has a number of joins and it was selecting * from all the
tables, so it was not apparent where each 'id' field was from. It was
just a poorly written query all around. I've fixed the problem by
narrowing down the number of fields it selects and giving the ambiguous
fields specific names