2 Replies Latest reply: Aug 25, 2011 9:50 AM by Klaus Skalts RSS

    Joining

    sandeepa rout

      TableA:

       

      orgcode

       

      orgname

       

      Orgtype

       

      address

       

      1

       

      tata

       

      Mnc

       

      aaa

       

      2

       

      birla

       

      Mnc

       

      bbb

       

      4

       

      jindal

       

      Mnc

       

      ccc

       

       

      TableB:

       

      Personcode

       

      title

       

      firstname

       

      lastname

       

      1

       

      dr

       

      Sandeepa

       

      Rout

       

      2

       

      mr

       

      Debashish

       

      rout

       

      4

       

      dr

       

      Surekha

       

      Nayak

       

       

      TableC:

       

      Orgcode

       

      Personcode

       

      Primaryaddress

       

      1

       

      1

       

      xx

       

      2

       

      2

       

      yy

       

      4

       

      4

       

      zz

       

       

       

       

      Table1:

       

      Orgcode

       

      Orgname

       

      Orgtypename

       

      Address

       

      1

       

      Tata

       

      Mnc

       

      aaa

       

      2

       

      Birla

       

      Mnc

       

      bbb

       

      3

       

      L&T

       

      Mnc

       

      eee

       

       

      4

       

      Jindal

       

      Mnc

       

      ccc

       

      5

       

      Adani

       

      Mnc

       

      ddd

       

      6

       

      Wipro

       

      Mnc

       

      fff

       

       

      Table2:

       

      Personcode

       

      Title

       

      Firstname

       

      Lastname

       

      1

       

      dr

       

      Sandeepa

       

      Rout

       

      2

       

      mr

       

      Debashish

       

      Rout

       

      3

       

      dr

       

      Sandeep

       

      Sahoo

       

      4

       

      dr

       

      Surekha

       

      Nayak

       

      5

       

      dr

       

      Abhimanyu

       

      Rout

       

      6

       

      dr

       

      Laxmipriya

       

      Nayak

       

       

       

       

      Table3:

       

      Orgcode

       

      Personcode

       

      Primaryaddress

       

      1

       

      1

       

      xxx

       

      2

       

      2

       

      yyy

       

      3

       

      3

       

      aaa

       

      4

       

      4

       

      zzz

       

      5

       

      5

       

      bbb

       

      6

       

      6

       

      ccc

       

       

       

      Output should be:

       

       

       

       

      Personcode

      tableA.orgcode

      Table1.orgcode

      tableA.orgname

      Table1.orgname

      matched

      1

      1

      1

      Tata

      tata

      matched

      2

      2

      2

      Birla

      birla

      matched

      3

      --

      3

      --

      L&T

      unmatched

      4

      4

      4

      Jindal

      jindal

      mathced

      5

      --

      5

      --

      adani

      unmatched

      6

      --

      6

      --

      wipro

      unmatched

       

       

      It means 1st we have to join tableA, tableb, tablec to one(tabA). Then table1, table2, table3 to one (Tab1).

       

      Then we have to compare TabA and Tab1.

       

      But We have to compare orgcode against personcode.

       

      Also we have to create a listbox as Matched where two options should be displayed. If we will click on matched or unmatched it will display accordingly..

       

      Please note: the matched field in output table is a label not a predefined field..

       

       

      Kindly suggest what to do...