0 Replies Latest reply: Jun 13, 2018 5:31 PM by sonam jaiswal RSS

    Help with Data Model

    sonam jaiswal

      I have 2 tables A and B.

       

      Table A has many columns 1,2 3........

      Table B has many columns 1,2,c.......

       

      i want to first find all matching as well non matching rows based on column 1 that is outer join on that. For all the resulting column 1 , i want to match column 2 for all those rows.

        Composite key is not working as desired.

      A
      aabbccddee
      1a
      2b
      2c
      4j

       

       

      B
      aabbxyz
      1a
      2b
      2c
      2d

      Thanks