db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Per Newgro <per.new...@gmx.ch>
Subject Tablealias as column qualifier in resultset
Date Tue, 05 Dec 2006 08:05:07 GMT
Hi,

i've a little question. 
If i execute the example-statement
  
  SELECT MYTABLE.* FROM myTable MYTABLE WHERE MYTABLE:A = 5;

i expected to access the column in resultset by usage of

  Object o = getObject("MYTABLE.A);

But this is throwing a ColumnNotFoundException. The other access is working.

  Object o = getObject("A);

I'm a little bit confused because how is derby solving same column names in a 
join of two tables, if the columns are not referenced by the qualifier?

Cheers
Per

Mime
View raw message