13 Replies Latest reply: Oct 9, 2013 7:56 AM by Poornima Shrivastava RSS

    how to fetch particular datavalues if table is as follows

      Hello frns,

      Again having problem, please help.

      I have three tables as:

       

      Table1                                   Table2                              Table3

      pk_Col1     Col2                  pk_Col3     Col4                fk_Col5    fk_Col6  col7

      A1     B1                              C1     D1                         A2          C3          E1

      A2     B2                              C2     D1                         A4          C1          E2

      A3     B3                              C3     D3                         A3          C4         E3

      A4     B4                              C4     D3                         A1          C2         E4

       

      SO THE QUERY IS :

       

      i want to access the data from table3 and col7 for the corresponding value of B3 AND D3

      means i want to fetch data E3 from table3 what expression i need to use..

       

       

      please reply as early as possible..

      Thanks..