Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A18D29FB6F4 for ; Wed, 6 Jun 2007 09:47:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 16225-06 for ; Wed, 6 Jun 2007 09:46:58 -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.251]) by postgresql.org (Postfix) with ESMTP id 984319FB410 for ; Wed, 6 Jun 2007 09:47:03 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so50737ana for ; Wed, 06 Jun 2007 05:47:02 -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=Plrne+r2Cao1cXunWj4pcV86F7UQstdd6/hKexYgtMm/CIQvhPmBIgtKWyg41JjnZhvRFZCStYoFvZJ0WzcT9EupIJ5ZFCKV8i7pDoq6SVL1nT57sG2egp/OwKg5DFiZgUMisKkIy07L9acDmC/NQYgwHL1dBAa+5SbrBta5Ah4= 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=LPnW6ralfyqduXOhunmH17v8UC1pR/4BG8nHFq8QuUM1M/X2Gp5H9vp/OEIfZfOZfNupF1UHA+KAIZK7W7bj5pnLlhbTqgQidyp/M5mtNP9nEGiqDImVus5/3YJRZKpDXvG7TV3e6qf6XAgYIRwksefema8GtgnOCtgOxoIgPJ4= Received: by 10.100.135.16 with SMTP id i16mr223556and.1181134022364; Wed, 06 Jun 2007 05:47:02 -0700 (PDT) Received: by 10.100.42.1 with HTTP; Wed, 6 Jun 2007 05:47:02 -0700 (PDT) Message-ID: <1c23c8e70706060547l692c0e0cn879daaf6f3a1b0d5@mail.gmail.com> Date: Wed, 6 Jun 2007 15:47:02 +0300 From: "Loredana Curugiu" To: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org Subject: Re: JOIN In-Reply-To: <1c23c8e70706060546r54a6cdbfr967d2f684bddf9c9@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_32855_31077171.1181134022259" References: <1c23c8e70706050708h6c5b708dpc2f53ff76a73740c@mail.gmail.com> <19770846.16757231181128801282.chat@gmail.com> <1c23c8e70706060447ib2925fftc5d34128e123e690@mail.gmail.com> <1c23c8e70706060542pfbec88crfca188149d2b3abd@mail.gmail.com> <1c23c8e70706060546r54a6cdbfr967d2f684bddf9c9@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/49 X-Sequence-Number: 18947 ------=_Part_32855_31077171.1181134022259 Content-Type: multipart/alternative; boundary="----=_Part_32856_5727616.1181134022259" ------=_Part_32856_5727616.1181134022259 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I forgot the attachement :) On 6/6/07, Loredana Curugiu wrote: > > 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_32856_5727616.1181134022259 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I forgot the attachement :)

On 6/6/07, Loredana Curugiu <loredana.curugiu@gmail.com> wrote:
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_32856_5727616.1181134022259-- ------=_Part_32855_31077171.1181134022259 Content-Type: text/x-sql; name=file.sql; charset=ANSI_X3.4-1968 Content-Transfer-Encoding: base64 X-Attachment-Id: f_f2lso01o Content-Disposition: attachment; filename="file.sql" Q1JFQVRFIFRBQkxFIHJlbWluZGVyX3NlcnZpY2VzICgKICAgICAgIHVpZCBTRVJJQUwsCiAgICAg ICB0aGVtZV91aWQgSU5UIE5PVCBOVUxMLAogICAgICAgYWN0aXZpdHlfTVRfYW1vdW50IElOVCBO T1QgTlVMTCwKICAgICAgIGFjdGl2aXR5X21pbl9kYXlzIElOVCBOT1QgTlVMTCwKICAgICAgIGFj dGl2aXR5X21heF9tb250aHMgSU5UIE5PVCBOVUxMLAogICAgICAgQ09OU1RSQUlOVCBwa19yZW1p bmRlcl9zZXJ2aWNlcyBQUklNQVJZIEtFWSh1aWQpLAogICAgICAgQ09OU1RSQUlOVCB1bl9yZW1p bmRlcl9zZXJ2aWNlc190aGVtZSBVTklRVUUodGhlbWVfdWlkKSApOwoKQ1JFQVRFIFRBQkxFIHRo ZW1lcyAoCiAgICAgICB1aWQgICAgICAgICAgIFNFUklBTCBQUklNQVJZIEtFWSwKICAgICAgIHRo ZW1lICAgICAgICAgVkFSQ0hBUigyNSkgVU5JUVVFIE5PVCBOVUxMICk7CgpDUkVBVEUgVEFCTEUg c2VudF9tZXNzYWdlcyAoCiAgICAgICB1aWQgICAgICBTRVJJQUwgUFJJTUFSWSBLRVksCiAgICAg ICByZWNlaXZlciBWQVJDSEFSKDI1KSwKICAgICAgIHRoZW1lICAgIFZBUkNIQVIoMjUpLAogICAg ICAgZGF0ZSAgICAgVElNRVNUQU1QIFdJVEggVElNRSBaT05FIE5PVCBOVUxMIERFRkFVTFQgQ1VS UkVOVF9USU1FU1RBTVAgKTsKCkNPUFkgcmVtaW5kZXJfc2VydmljZXMgRlJPTSBzdGRpbiBXSVRI IERFTElNSVRFUiAnfCc7CiAgNSB8ICAgICAgICAgNiB8ICAgICAgICAgICAgICAgICAgMyB8ICAg ICAgICAgICAgICAgICA2IHwgICAgICAgICAgICAgICAgICAgMQogIDYgfCAgICAgICAgIDcgfCAg ICAgICAgICAgICAgICAgIDQgfCAgICAgICAgICAgICAgICAgNSB8ICAgICAgICAgICAgICAgICAg IDEKXC4KCkNPUFkgdGhlbWVzIEZST00gc3RkaW4gV0lUSCBERUxJTUlURVIgJ3wnOwo2IHwgQ1JJ U1RJCjcgfCBMSUEKXC4KCkNPUFkgc2VudF9tZXNzYWdlcyBGUk9NIHN0ZGluIFdJVEggREVMSU1J VEVSICd8JzsKICA2MiB8ICs0MDc0MTc3NTYyMiB8IENSSVNUSSB8IDIwMDctMDYtMDQgMDc6NDQ6 NDUuNDA2MjcxKzAwCiAgNzAgfCArNDA3NDE3NzU2MjIgfCBDUklTVEkgfCAyMDA3LTA2LTA0IDA3 OjQ1OjAxLjc4ODUzMyswMAogIDcxIHwgKzQwNzQxNzc1NjIyIHwgQ1JJU1RJIHwgMjAwNy0wNi0w NCAwNzo0NTowMy43NjQ1MDYrMDAKICA4MCB8ICs0MDc0MTc3NTYyMSB8IExJQSAgICB8IDIwMDct MDYtMDQgMDc6NDU6MjYuMzA5MjE1KzAwCiAgODEgfCArNDA3NDE3NzU2MjEgfCBMSUEgICAgfCAy MDA3LTA2LTA0IDA3OjQ1OjI4LjMxNDA3NSswMAogIDYzIHwgKzQwNzQxNzc1NjIyIHwgQ1JJU1RJ IHwgMjAwNy0wNi0wMyAwNzo0NDowMCswMAogIDY0IHwgKzQwNzQxNzc1NjIyIHwgQ1JJU1RJIHwg MjAwNy0wNi0wMiAwNzo0NDowMCswMAogIDY1IHwgKzQwNzQxNzc1NjIyIHwgQ1JJU1RJIHwgMjAw Ny0wNi0wMSAwNzo0NDowMCswMAogIDY2IHwgKzQwNzQxNzc1NjIyIHwgQ1JJU1RJIHwgMjAwNy0w Ni0wMSAwNzo0NDowMCswMAogIDY3IHwgKzQwNzQxNzc1NjIyIHwgQ1JJU1RJIHwgMjAwNy0wNi0w MSAwNzo0NDowMCswMAogIDY4IHwgKzQwNzQxNzc1NjIyIHwgQ1JJU1RJIHwgMjAwNy0wNC0wMSAw Nzo0NDowMCswMAogIDY5IHwgKzQwNzQxNzc1NjIyIHwgQ1JJU1RJIHwgMjAwNy0wNS0wMSAwNzo0 NDowMCswMAogIDcyIHwgKzQwNzQxNzc1NjIxIHwgTElBICAgIHwgMjAwNy0wNi0wMyAwNzo0NDow MCswMAogIDczIHwgKzQwNzQxNzc1NjIxIHwgTElBICAgIHwgMjAwNy0wNi0wMyAwNzo0NDowMCsw MAogIDc0IHwgKzQwNzQxNzc1NjIxIHwgTElBICAgIHwgMjAwNy0wNi0wMiAwNzo0NDowMCswMAog IDc1IHwgKzQwNzQxNzc1NjIxIHwgTElBICAgIHwgMjAwNy0wNi0wMiAwNzo0NDowMCswMAogIDc2 IHwgKzQwNzQxNzc1NjIxIHwgTElBICAgIHwgMjAwNy0wNi0wMSAwNzo0NDowMCswMAogIDc3IHwg KzQwNzQxNzc1NjIxIHwgTElBICAgIHwgMjAwNy0wNi0wMSAwNzo0NDowMCswMAogIDc4IHwgKzQw NzQxNzc1NjIxIHwgTElBICAgIHwgMjAwNy0wNi0wMSAwNzo0NDowMCswMAogIDc5IHwgKzQwNzQx Nzc1NjIxIHwgTElBICAgIHwgMjAwNy0wNi0wMSAwNzo0NDowMCswMApcLgoKCiAgICBTRUxFQ1Qg U1VNKEIuY291bnQpLCAKICAgICAgICAgICBBLnRoZW1lLCAKICAgICAgICAgICBBLnJlY2VpdmVy LCAKICAgICAgICAgICBBLmRhdGVzCiAgICAgIEZST00gKCBTRUxFQ1QgRElTVElOQ1QgQ09VTlQo KiksIAogICAgICAgICAgICAgICAgICAgIHNlbnRfbWVzc2FnZXMudGhlbWUsIAogICAgICAgICAg ICAgICAgICAgIHJlY2VpdmVyLCAKICAgICAgICAgICAgICAgICAgICBBUlJBWShTRUxFQ1QgZGF0 ZTo6ZGF0ZSArIHMuYSBGUk9NIGdlbmVyYXRlX3NlcmllcygwLGFjdGl2aXR5X21pbl9kYXlzKSBB UyBzKGEpKSBBUyBkYXRlcyAKICAgICAgICAgICAgICBGUk9NIHJlbWluZGVyX3NlcnZpY2VzLCB0 aGVtZXMsc2VudF9tZXNzYWdlcyAKICAgICAgICAgICAgIFdIRVJFIHRoZW1lcy51aWQ9cmVtaW5k ZXJfc2VydmljZXMudGhlbWVfdWlkIAogICAgICAgICAgICAgICBBTkQgVFJJTShzZW50X21lc3Nh Z2VzLnRoZW1lKT1UUklNKHRoZW1lcy50aGVtZSkgCiAgICAgICAgICAgICAgIEFORCBkYXRlX3Ry dW5jKCdkYXknLHNlbnRfbWVzc2FnZXMuZGF0ZSkgPiAobm93KCkgLSByZW1pbmRlcl9zZXJ2aWNl cy5hY3Rpdml0eV9tYXhfbW9udGhzICogSU5URVJWQUwnIDEgbW9udGgnKSAKICAgICAgICAgICAg IEdST1VQIEJZIHNlbnRfbWVzc2FnZXMudGhlbWUsIHJlY2VpdmVyLCBkYXRlLCBhY3Rpdml0eV9t aW5fZGF5cyApIEEKSU5ORVIgSk9JTiAoIFNFTEVDVCBDT1VOVCgqKSwgCiAgICAgICAgICAgICAg ICAgICAgc2VudF9tZXNzYWdlcy50aGVtZSwgCiAgICAgICAgICAgICAgICAgICAgcmVjZWl2ZXIs IAogICAgICAgICAgICAgICAgICAgIGRhdGVfdHJ1bmMoJ2RheScsc2VudF9tZXNzYWdlcy5kYXRl KSBBUyBkYXRlCiAgICAgICAgICAgICAgRlJPTSByZW1pbmRlcl9zZXJ2aWNlcywgdGhlbWVzLHNl bnRfbWVzc2FnZXMgCiAgICAgICAgICAgICBXSEVSRSB0aGVtZXMudWlkPXJlbWluZGVyX3NlcnZp Y2VzLnRoZW1lX3VpZCAKICAgICAgICAgICAgICAgQU5EIFRSSU0oc2VudF9tZXNzYWdlcy50aGVt ZSk9VFJJTSh0aGVtZXMudGhlbWUpIAogICAgICAgICAgICAgICBBTkQgZGF0ZV90cnVuYygnZGF5 JyxzZW50X21lc3NhZ2VzLmRhdGUpID4gKG5vdygpIC0gcmVtaW5kZXJfc2VydmljZXMuYWN0aXZp dHlfbWF4X21vbnRocyAqIElOVEVSVkFMJyAxIG1vbnRoJykgCiAgICAgICAgICAgICBHUk9VUCBC WSBzZW50X21lc3NhZ2VzLnRoZW1lLCByZWNlaXZlciwgZGF0ZSwgYWN0aXZpdHlfbWluX2RheXMg KSBCIAogICAgICAgIE9OIEEudGhlbWU9Qi50aGVtZSAKICAgICAgIEFORCBBLnJlY2VpdmVyPUIu cmVjZWl2ZXIgCiAgICAgICBBTkQgQi5kYXRlPUFOWSAoQS5kYXRlcykgCiAgR1JPVVAgQlkgQS50 aGVtZSwgQS5yZWNlaXZlciwgQS5kYXRlczsKCg== ------=_Part_32855_31077171.1181134022259--