Left join?

Hi,

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
 
(4 rows)

Thanks in advance,

Carlos

__________________________________________________
Table definitions:

postgres=# \d func    Table "public.func"Column |  Type   | Modifiers
--------+---------+-----------codfun | integer | not nullnome   | text    |
Indexes:   "func_pkey" PRIMARY KEY, btree (codfun)

postgres=# \d reqtran   Table "public.reqtran"Column |  Type   | Modifiers
--------+---------+-----------codreq | integer | not nullcodsol | integer |codate | integer |codfec | integer |
Indexes:   "reqtran_pkey" PRIMARY KEY, btree (codreq)
Foreign-key constraints:   "reqtran_codate_fkey" FOREIGN KEY (codate) REFERENCES func(codfun)   "reqtran_codfec_fkey"
FOREIGNKEY (codfec) REFERENCES func(codfun)   "reqtran_codsol_fkey" FOREIGN KEY (codsol) REFERENCES func(codfun)
 
__________________________________________________
Table contents:

postgres=# select * from func;codfun | nome
--------+-------     1 | nome1     2 | nome2     3 | nome3
(3 rows)

postgres=# select * from reqtran;codreq | codsol | codate | codfec
--------+--------+--------+--------     1 |        |        |     2 |      1 |        |     3 |      1 |      1 |     4
|     1 |      1 |      1
 
(4 rows)