Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 94959 invoked from network); 30 May 2006 21:02:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 May 2006 21:02:34 -0000 Received: (qmail 95218 invoked by uid 500); 30 May 2006 21:02:33 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 95190 invoked by uid 500); 30 May 2006 21:02:32 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 95179 invoked by uid 99); 30 May 2006 21:02:32 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 May 2006 14:02:32 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.1.36] (HELO gmpea-pix-1.sun.com) (192.18.1.36) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 May 2006 14:02:31 -0700 Received: from d1-emea-03.sun.com ([192.18.2.113]) by gmpea-pix-1.sun.com (8.12.9/8.12.9) with ESMTP id k4UL2A4x002695 for ; Tue, 30 May 2006 22:02:10 +0100 (BST) Received: from conversion-daemon.d1-emea-03.sun.com by d1-emea-03.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) id <0J0300I01EKSOL00@d1-emea-03.sun.com> (original mail from Bernt.Johnsen@Sun.COM) for derby-user@db.apache.org; Tue, 30 May 2006 22:02:10 +0100 (BST) Received: from localhost (180.80-203-115.nextgentel.com [80.203.115.180]) by d1-emea-03.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPSA id <0J0300KJYJRKLE40@d1-emea-03.sun.com> for derby-user@db.apache.org; Tue, 30 May 2006 22:02:10 +0100 (BST) Date: Tue, 30 May 2006 23:01:47 +0200 From: "Bernt M. Johnsen" Subject: Re: Column 'XXXX' is not in any table in the FROM list.... In-reply-to: Sender: Bernt.Johnsen@Sun.COM To: Derby Discussion Message-id: <20060530210147.GA23742@localhost.localdomain> Organization: Sun Microsystems MIME-version: 1.0 Content-type: multipart/signed; boundary=FL5UXtIhxfXey3p5; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-disposition: inline References: User-Agent: Mutt/1.5.9i X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --FL5UXtIhxfXey3p5 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable >>>>>>>>>>>> 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.=20 texto and Texto and TEXTO is the same identifier, while "texto" and "Texto" is two other and different identifiers --=20 Bernt Marius Johnsen, Database Technology Group,=20 Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway --FL5UXtIhxfXey3p5 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFEfLK7lFBD9TXBAPARAtbuAKCpx2LgutvsBfiYd8Xmwxbv4bPRrACgwUhf 3+x6KttfXGrFY6jwa9P9ZaI= =xC7g -----END PGP SIGNATURE----- --FL5UXtIhxfXey3p5--