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?


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

View raw message