Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 73D279FB450 for ; Wed, 6 Jun 2007 09:46:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 56763-03 for ; Wed, 6 Jun 2007 09:46:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.240]) by postgresql.org (Postfix) with ESMTP id C66C79FB410 for ; Wed, 6 Jun 2007 09:46:27 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so50650ana for ; Wed, 06 Jun 2007 05:46:26 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=aiRsclCHKBkCpu8w4WHS6DvDRsP2kMByCTAiIfwP7WWkUpGRtJV/Kt2aHB3K+F0NSFTlTMg/1EVe2SkCCOR/UGXT47H4bhjmRSmknlSFXgJiS6pTf+hZGzGRo4A706HMpPmbMbcSzw02zfFKBTmQi7CHWNeGdYK59aygvksA4jo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=OjgMNKycRuaTqb+2IIVGaSWfnffvXzFSQxTQ+6ZkJicmN1yBAI5L7l032fSx7wG6w6/a/mvi4UNjKZaapvzCAFFTskgumQecq2eTrllqjK4XQsNYp/tM3Cp+Y9B1v8fjqIHTD6jkDPmdhKR2yelLN48y4+XZvUDvLkfivYjHBus= Received: by 10.101.14.16 with SMTP id r16mr240323ani.1181133986424; Wed, 06 Jun 2007 05:46:26 -0700 (PDT) Received: by 10.100.42.1 with HTTP; Wed, 6 Jun 2007 05:46:26 -0700 (PDT) Message-ID: <1c23c8e70706060546r54a6cdbfr967d2f684bddf9c9@mail.gmail.com> Date: Wed, 6 Jun 2007 15:46:26 +0300 From: "Loredana Curugiu" To: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org Subject: Re: JOIN In-Reply-To: <1c23c8e70706060542pfbec88crfca188149d2b3abd@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_32844_5925276.1181133986376" References: <1c23c8e70706050708h6c5b708dpc2f53ff76a73740c@mail.gmail.com> <19770846.16757231181128801282.chat@gmail.com> <1c23c8e70706060447ib2925fftc5d34128e123e690@mail.gmail.com> <1c23c8e70706060542pfbec88crfca188149d2b3abd@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/48 X-Sequence-Number: 18946 ------=_Part_32844_5925276.1181133986376 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I found my problem. I attaches an .sql file with my tables, data and my new query. If you are interested you can take a look. Thanks to all. Regards, Loredana ------=_Part_32844_5925276.1181133986376 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I found my problem. I attaches an .sql file with my tables, data
and my new query. If you are interested you can take a look.

Thanks to all.

Regards,
     Loredana
------=_Part_32844_5925276.1181133986376--