>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.
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?
|• Select question||Erich C. Beyrent||17 May|
| • Re: Select question||Peter Brawley||17 May|