> 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.
