Re: [SQL] Altnerate Column Return Names

2000-07-07 Thread Peter Eisentraut
Thomas Swan writes: > If I do a select * from table1, table2 where table1.id = table2.id I > normally get two columns returned with a column identifier of id. > id | name | data | id | name | data > +--+--++--+-- > Is there anyway to get the result to return > > ta

[SQL] Altnerate Column Return Names

2000-07-07 Thread Thomas Swan
If I do a select * from table1, table2 where table1.id = table2.id I normally get two columns returned with a column identifier of id. Such as id | name | data | id | name | data +--+--++--+-- | | || | Is there anyway to get the result to retu