DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=FwtfdFNpB+N0t9ODwQLmsUxMyQZ1oEf18Ua3kNMOb84/wqKqkaZcw48ECgVw9iatFlwDVcmjJt80EbzqbzY6rlgCGSBNBGDdFoY0UjceuYisoTDlGrOkgndItEl7C/2Mhc/LzXyc+pi5rq2gkgejal36oRBnpKhSBk0TXsVbu34=
	;
Message-ID: <20060701214445.36616.qmail@web31805.mail.mud.yahoo.com>
Date: Sat, 1 Jul 2006 14:44:45 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: Left join?
To: carlosreimer@terra.com.br, pgsql-sql@postgresql.org
In-Reply-To: <PEEPKDFEHHEMKBBFPOOKKEFCDCAA.carlosreimer@terra.com.br>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

> In the following table, codsol, codate and codfec are foreign keys
> referencing table func and I need some help to codify a  SELECT command that
> produces the following result set but instead of codsol, codate and codfec I
> need the respectives names (column nome from table func).
> 
> postgres=# select * from reqtran;
>  codreq | codsol | codate | codfec
> --------+--------+--------+--------
>       1 |        |        |
>       2 |      1 |        |
>       3 |      1 |      1 |
>       4 |      1 |      1 |      1
> postgres=# \d func

>      Table "public.func"
>  Column |  Type   | Modifiers
> --------+---------+-----------
>  codfun | integer | not null
>  nome   | text    |

> Indexes:
>     "reqtran_codate_fkey" FOREIGN KEY (codate) REFERENCES func(codfun)
>     "reqtran_codfec_fkey" FOREIGN KEY (codfec) REFERENCES func(codfun)
>     "reqtran_codsol_fkey" FOREIGN KEY (codsol) REFERENCES func(codfun)

Would this do what you need?
 
select R1.codreq, 
       CS.nome, 
       CD.nome, 
       CF.nome
from rectran as R1 
   left join func as CS on (R1.codsol=CS.codefun) 
   left join func as CD on (R1.codate=CD.codefun)
   left join func as CF on (R1.codfec=CF.codefun)
;

Regards,

Richard Broersma Jr.