Ok I got it. There is no way to alias all columns of some table with
some "prefix" that will be visible in result except to alias each
column.
Tnx Nick, Micsha
P.S. sorry for my bad english
On 8/11/05, Nick Stone <[EMAIL PROTECTED]> wrote:
> Yes - just alias the columns you need to alias
>
> Nic
Thanks
Sorry, my question was missing one important detail. My tables have
quite a lot columns (which unfortunately have same names in both
tables) so is it possible to do same as below but without specifying
alias for each column. Now my queries are long and they do not look
nice.
boris
On 8/11
Hi,
If I have:
1.) table car with columns index and name
2.) table driver with columns index, name and car_index
and query:
SELECT d.*, c.* FROM driver as d LEFT OUTER JOIN car AS c ON
d.car_index=c.index;
How can I get results that have distinct names for columns (ex.
d.name, d.index, c.name,
