8 Replies Latest reply: Dec 22, 2014 10:12 AM by Sudhanshu Shrivas RSS

    need to left join sql table in qlikview

    Sudhanshu Shrivas

      hi,

       

      i have VBRK table and VBRP table of SAP

       

      I have fetched data from VBRK table for 1 year on fkdat field.

       

      now I need to fetch data from VBRP table on VBELN field  using VBRK tables FKDAT.

       

      so I need to do left join on the basis of VBELN FEILD BETWEEN BOTH TABLE(VBRK  and VBRP).

       

      NEED HELP IN PERFORMING LEFT JOIN IN SQL ON QLIKVIEW SCRIPT BETWEEN VBRK AND VBRP TABLE.

       

      THANKS