Jakub
Brass Tilde wrote:
The last one is really annoying and I can't believe the auto-tests could have missed it ...
create table a (id, x); create table b (id, y); insert into a values (1,1); insert into b values (1,2); select * from a inner join b;
column names returned: id,x,id,y
You'll get the same result when you execute that query in SQL Server 2000. I suspect you'll get the same result from a lot of SQL DB systems.
How am I supposed to use such column names?
The same way every other programmer does, by using alias on the fields that you are interested in, and leaving the others out of it.
--
Jakub Adamek Programmer Telematix Software, a.s. Karoliny Svetle 12, Praha 1 http://www.telematix.cz Tel: +420 608 247197 Office: +420 224233470
