I have three tables (x, y, and z) with the same 3 fields (id, name,
number). If I do:
SELECT * FROM x, y, z WHERE ...
each row of my result will contain 3 id fields, 3 name fields, and 3
number fields.
Of course, I can/should do:
SELECT x.id AS x_id, x.name AS x_name, x.number AS x_number,
]
To: mysql@lists.mysql.com
Sent: Monday, December 11, 2006 8:39 PM
Subject: Prefixing fields with table name when joining?
I have three tables (x, y, and z) with the same 3 fields (id, name,
number). If I do:
SELECT * FROM x, y, z WHERE ...
each row of my result will contain 3 id fields, 3 name