X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5FF6B47639B for ; Tue, 29 Apr 2003 06:43:24 -0400 (EDT) Received: from shield.nordlb.lv (shield.pirmabanka.lv [195.114.57.4]) by postgresql.org (Postfix) with ESMTP id 1A4D64763AC for ; Tue, 29 Apr 2003 06:42:46 -0400 (EDT) Received: from wall2.pirmabanka.lv (wall2-pub.pirmabanka.lv [195.114.57.14]) by shield.nordlb.lv (8.12.9/8.12.9) with SMTP id h3TAgfNL011753 for ; Tue, 29 Apr 2003 13:42:41 +0300 Received: from share.pirmabanka.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Tue, 29 Apr 2003 13:42:39 +0300 (EET DST) Received: from pc311x1.nordlb.lv (localhost.localdomain [127.0.0.1]) by nordlb.lv (8.11.6/8.11.6) with SMTP id h3TAgdu20320 for ; Tue, 29 Apr 2003 13:42:39 +0300 Received: (qmail 29520 invoked by uid 100); 29 Apr 2003 10:44:21 -0000 Date: Tue, 29 Apr 2003 13:44:21 +0300 From: "Victor Yegorov" To: rute solipa Cc: Rajesh Kumar Mallah , pgsql-sql@postgresql.org Subject: Re: help query Message-ID: <20030429104421.GG27788@nordlb.lv> Mail-Followup-To: rute solipa , Rajesh Kumar Mallah , pgsql-sql@postgresql.org References: <3EAD4E78.80204@eselx.ipl.pt> <5.0.2.1.0.20030429101227.00a4d490@mail.eselx.ipl.pt> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="5/uDoXvLw7AC5HRs" Content-Disposition: inline In-Reply-To: <5.0.2.1.0.20030429101227.00a4d490@mail.eselx.ipl.pt> User-Agent: Mutt/1.4.1i X-Spam-Status: No, hits=-26.8 required=5.0 tests=BAYES_10,IN_REP_TO,NO_DNS_FOR_FROM,PGP_SIGNATURE_2, REFERENCES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/424 X-Sequence-Number: 13125 --5/uDoXvLw7AC5HRs Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * rute solipa [29.04.2003 13:36]: > hi everyone, >=20 > does anyone can help me with this query, i need to now if it's a possible= =20 > query and where do i put the join clause. >=20 > kind regards, Go here: http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D1&file=3Dqueri= es-table-expressions.html and read all about joins. --=20 Victor Yegorov --5/uDoXvLw7AC5HRs Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+rleF2RKGLEykUDYRArrXAJ914z0neWQ3pQTtcZiyPU14rJ4lrQCgsugp BFmzdFxR9/7DYH3JQs5LGcU= =Ac6c -----END PGP SIGNATURE----- --5/uDoXvLw7AC5HRs--