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 null
nome | text |
Indexes:
"func_pkey" PRIMARY KEY, btree (codfun)

postgres=# \d reqtran
Table "public.reqtran"
Column | Type | Modifiers
--------+---------+-----------
codreq | integer | not null
codsol | 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" FOREIGN KEY (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)