1 Reply Latest reply: Oct 22, 2012 5:41 AM by Srini VEERAVALLI RSS

    Derived from existing columns

    883915
      Hi,

      how to create a new column that's derive data from another table on this logic:

      table A
      ID name
      1 dsf
      2 sdf
      3 sdd

      table B
      ID name tableA_ID
      1 dd 1
      2 de 2


      I added another column in table A in desperation to denormalize our data and doesnt need to make a join to table B
      ID name tableB_name
      1 dsf dd
      2 sdf de
      3 sdd

      basically just trying merging 2 table with 1-1 relationship. I tried to populate data from table B into A but it's making an inner join and when i query data, row ID 3 in table A doesnt return