1. Create the IMPORT_SALES_XX table based on the old Sales table

2. Create the IMPORT_MGRS_XX table based on the old Managers table

3. Create the IMPORT_OE_XX table based on the old Operational Expenses table

4. Create a SELECT that joins the previous three IMPORT tables together

SELECT OldColumn1 AS NewColumn1,

OldColumn2 AS NewColumn2,

...

OldCoumnN AS NewColumnN

FROM ...

 

5. Confirm each new column name alias in your SELECT is unique

 

6. Add to your SELECT the PrimaryID column and then each table primary ID column name from each table in your database design diagram. Use NULL AS TableID. For instance:

 

SELECT ROWNUM AS PrimaryID,

NULL AS EmployeeID,

NULL AS  CustomerID,

...

 

7. Create the IMPORT_ALL_XX table where XX is your initials using CREATE TABLE then adding your SELECT

 

CREATE TABLE IMPORT_ALL AS

-- your select goes here

 

8. Create the IMPORT_ALL_XX table where XX is your initials using CREATE TABLE then adding your SELECT
 

M Managers ManagerFirstName ManagerlastName ManagerTitle EmployeeFirstName EmplooyeeLastName EmployeeTitle OperationExpenses EmployeeFirstName/VendorName EmployeeLastName PaymentType Payment Amount Payment Date Address Quanity Apt City Province PostalCode Comments Sales Company Name RecipientFirstName RecipientLastName Product Quanity Address Apt Province Postal Code PricePerUnit TotalPrice Sales ManFirstName Sales ManastName