Design question

I have two tables:

Create table CUST (

  Cust_id number(10),
  Name_First varchar2(10),
  Name_Last varchar2(15));

Create table CUST_AKA(
  Cust_Aka_Id number(10),
  Name varchar2( 15 ),
  Cust_Id number(10));

I would like to create a view with Cust_Id, Name.

For any Cust_ID, the view would consist of 2 or more rows. One where Name = Cust.Name_First, one where Name = Cust.Name_Last, and one row each for all values in Cust_AKA.Name.

What would be the most efficient way to accomplish this?

Thanks

--
Jim Poe (jpoe_at_fulcrumit.com)