From: | "Carlos H(dot) Reimer" <carlosreimer(at)terra(dot)com(dot)br> |
---|---|
To: | "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | RES: Left join? |
Date: | 2006-07-02 12:52:35 |
Message-ID: | PEEPKDFEHHEMKBBFPOOKOEFIDCAA.carlosreimer@terra.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
It´s just want I need! Perfect! Thanks!
Carlos
> -----Mensagem original-----
> De: Richard Broersma Jr [mailto:rabroersma(at)yahoo(dot)com]
> Enviada em: sábado, 1 de julho de 2006 18:45
> Para: carlosreimer(at)terra(dot)com(dot)br; pgsql-sql(at)postgresql(dot)org
> Assunto: Re: [SQL] Left join?
>
>
> > 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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Hima Surapaneni | 2006-07-02 22:30:01 | Can't drop table |
Previous Message | Richard Broersma Jr | 2006-07-01 21:44:45 | Re: Left join? |