3 Replies Latest reply: Aug 29, 2016 4:40 PM by yuan du RSS

    Join two tables and fill up null values from both tables

    yuan du

      I have two Tables below. They have the same key and field. The reason to merge the two tables is that I want to fill up the null values in TableA with values from TableB but still keep all key in from both tables.

      TableA:

      KeyField
      110
      2
      330

      TableB:

      KeyField
      220
      440

      The merged table should be look like:

      KeyField
      110
      220
      330
      440

       

      Thank you in advance!