Forum Discussion

SteveBrou's avatar
SteveBrou
Frequent Visitor
6 years ago

Creating New Table from fields from 2 existing tables

I would like to create a new table using particular columns from an existing table 1 and an existing table 2. Some of these columns are the same fields in both table 1 and table 2 (e.g. First Name, L...
  • SteveBrou's avatar
    SteveBrou
    Frequent Visitor
    6 years ago

    Table 1                                  Table 2

    Job Title                                 Job Title

    LCAT                                      First Name

    First Name                             Last Name

    Last Name                             Target Start Date

    Target Start Date                   Subcontractor Name

     

    Expected Output (New Table)

    Job Title

    FIrst Name

    Last Name

    Target Start Date

    Subcontractor Name

     

    Since the subcontractor name field only exists in table 2, the only rows that would have a value in subcontractor name column are those rows from table 2. The rows from table 1 would have no value in that column.

     

    Thanks!