db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: Column 'XXXX' is not in any table in the FROM list....
Date Tue, 30 May 2006 21:01:47 GMT
>>>>>>>>>>>> Alexandre Gomes wrote (2006-05-30 16:27:20):
> Take a look at this screenshot. The SQL statement is quite simple
> "select texto from ACORDAO". On the left, you can see ACORDAO table
> and its 'texto' column. Am I so tired that I cannot see the problem?

try

select "texto" from acordao;

Note that SQL is case insensitive, but identifiers may be quoted. 

texto and Texto and TEXTO is the same identifier, while "texto" and
"Texto" is two other and different identifiers

-- 
Bernt Marius Johnsen, Database Technology Group, 
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

Mime
View raw message