Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7810A4769F2 for ; Fri, 30 Aug 2002 13:02:36 -0400 (EDT) Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id CFACF4769EE for ; Fri, 30 Aug 2002 13:02:35 -0400 (EDT) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.5.9) with ESMTP id 1629180; Fri, 30 Aug 2002 10:02:34 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "Zenith Vivas" , pgsql-sql@postgresql.org Subject: Re: How to Select with more than one AND in a Where SQL Clause? Date: Thu, 29 Aug 2002 11:59:08 -0700 X-Mailer: KMail [version 1.4] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200208291159.08806.josh@agliodbs.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/426 X-Sequence-Number: 9272 Zenith, > Qry =3D "Select * from Table Where A1 Like '%' AND A2 Like '%' AND A3 Lik= e '%'=20 > AND A4 Like '%' AND A5 Like '%'" >=20 > But in spite of I need a SQL sentence with four (04) AND's in its Where= =20 > clause, my SQL compiler only allow me using one AND. >=20 > So How can I solve such a problem. This is not a PostgreSQL problem, it is a problem with whatever program you= 're=20 using. Use different database tools, or access PostgreSQL directly throug= h=20 PSQL. --=20 -Josh Berkus Aglio Database Solutions San Francisco