Want mysql to return tablename.fieldname format

2006-03-02 Thread Ryan Stille
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 name the fields with the table name when they are returned, so they

RE: Want mysql to return tablename.fieldname format

2006-03-02 Thread Marciano [Intercol]
mysql to return tablename.fieldname format 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 name the fields with the table

Re: Want mysql to return tablename.fieldname format

2006-03-02 Thread SGreen
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

Re: Want mysql to return tablename.fieldname format

2006-03-02 Thread Rhino
- From: Ryan Stille [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, March 02, 2006 12:42 PM Subject: Want mysql to return tablename.fieldname format 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

RE: Want mysql to return tablename.fieldname format

2006-03-02 Thread Ryan Stille
' column. -- Rhino - Original Message - From: Ryan Stille [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, March 02, 2006 12:42 PM Subject: Want mysql to return tablename.fieldname format I am working with an existing compilcated query someone wrote years ago. When I