Question on Select Statement

Hi,

   I have a master/detail relationship tables as below:

       create table  Master(PrimKey number, Otherkey varchar2(20));
          insert into   Master values (1,'HELLO');
          insert into   Master values (2,'BYE');


       create table  Detail(ForeignKey number, column1 number);
          insert into   Detail values (1, 200);
          insert into   Detail values (1, 300);
          insert into   Detail values (1, 400);

       commit;

  Question:

  Can I construct a select statement that will return "one and only one"   row containing all detail for this tables relationship.

  The idea result row shoud look like:

      1 HELLO 200 300 400   Thanks in advance for your help. Received on Wed Aug 20 1997 - 00:00:00 CDT