sql question

Hi all,

create table t_
(trimester number(1),
month_id number(2),
month_name varchar(3));

insert into t_ values (1,1,'JAN');
insert into t_ values (1,2,'FEB');
insert into t_ values (1,3,'MAR');
insert into t_ values (1,4,'APR');
insert into t_ values (2,5,'MAY');
insert into t_ values (2,6,'JUN');
insert into t_ values (2,7,'JUL');
insert into t_ values (2,8,'AUG');
insert into t_ values (3,9,'SEP');
insert into t_ values (3,10,'OCT');
insert into t_ values (3,11,'NOV');
insert into t_ values (3,12,'DEC');

commit;

select * from t_ where trimester = 2;

TRIMESTER	MONTH_ID	MONTH_NAME
2	           5	             MAY
2	           6	             JUN
2	           7	             JUL
2	           8	             AUG

Question: how can i list all month for given trimester in one row??? For instance:

TRIMESTER      MONTH_1    MONTH_2    MONTH_3    MONTH_4
 2              MAY        JUN         JUL         AUG

Thanks,
Eugene Received on Thu May 04 2006 - 16:44:43 CDT