Re: sql problem with join - Mailing list pgsql-sql

From Luca Ferrari
Subject Re: sql problem with join
Date
Msg-id 200611151759.58103.fluca1978@infinito.it
Whole thread Raw
In response to Re: sql problem with join  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: sql problem with join
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: sql problem with join
Next
From: Jim Nasby
Date:
Subject: Re: [HACKERS] Case Preservation disregarding case