12 Replies Latest reply: Mar 7, 2014 4:29 AM by Manish Kachhia RSS

    lookup scenario

    vijeta sharma

      Hi everyone,

      I am having tables,

      t1:                       

      id1,id2,value

      A,1,100

      B,2,120

      C,3,140

      t2:

      id1,pg1

      A,pqr

      B,

      D,xyz

      E,123

      t3:

      id2,pg2

      1,abc

      2,mno

      3,tuv

      4,xyz

      after joining I want output like,

      id1,id2,pg1,value

      A,1,pqr,100

      B,2,mno,120

      how should I achieve it?