creation of new table

Hi,

I will have to create a new table OPRDEF in which there shoud be seven columns (OPRID,EMPLID,EMAILID,NAME,LAST_NAME ,FIRST_NAME, MIDDLE_NAME) from below given tables . All the columns should contain valus .There should be no null values 

In first table PSOST there are 65000 records there ,in 2nd table personal 100000 records are there and in 3rd table active_data 8000  records are there . These tables contain many null values.

In active_data table  EMAILID  is always correct and in personal table EMPID is always correct. Based on it the above I will have to create the new table OPRDEF.