Erich,
>Is there a way to set a prefix for each table so that
>the results come out like tablename.column?
Use a scripting or application language to automate & parameterise query
generation. SQL is just a partial computing language.
PB
-----
Erich C. Beyrent wrote:
I have three tables, all of which have a 'name' column.
If I do:
select table1.*, table2.*, table3.* from ....
I'll end up with a result set that has three 'name' fields, but no way
to distinguish which table the field belongs to.
I know I can select individual columns like:
select table1.name as foo, table2.name as bar ...
but I need all the columns from each table and that will be very
tedious. Is there a way to set a prefix for each table so that the
results come out like tablename.column?
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
