Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E216F9F9EED for ; Wed, 15 Nov 2006 13:00:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19654-05 for ; Wed, 15 Nov 2006 13:00:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from aa016msg.fastweb.it (aa016msg.fastweb.it [213.140.2.83]) by postgresql.org (Postfix) with ESMTP id 550689F9C9E for ; Wed, 15 Nov 2006 13:00:25 -0400 (AST) Received: from ms006msg.fastweb.it (10.31.41.46) by aa016msg.fastweb.it (7.3.105.6) id 4535D64500D3E9F5 for pgsql-sql@postgresql.org; Wed, 15 Nov 2006 17:58:52 +0100 Received: from [192.168.201.201] (89.97.40.40) by ms006msg.fastweb.it (7.2.070) id 44AD188303714B07 for pgsql-sql@postgresql.org; Wed, 15 Nov 2006 18:00:23 +0100 From: Luca Ferrari To: pgsql-sql@postgresql.org Subject: Re: sql problem with join Date: Wed, 15 Nov 2006 17:59:58 +0100 User-Agent: KMail/1.9.5 References: <30186.45923.qm@web31807.mail.mud.yahoo.com> In-Reply-To: <30186.45923.qm@web31807.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200611151759.58103.fluca1978@infinito.it> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/156 X-Sequence-Number: 26808 On Wednesday 15 November 2006 16:20 your cat, walking on the keyboard, wrote: > May be you could show the results you are getting and then make up some > results that you would really like to get. I am not entirely clear what > you are trying to achieve. Lastly I found the solution, for the moment, that should be the following: select * from peopleRole pr left join roleSkill rs on rs.id_role = pr.id_role left join peopleSkill ps on ps.id_skill = rs.id_skill I think it should go, don't you think? Thanks, Luca