2 Replies Latest reply: Feb 14, 2018 12:40 PM by Johan Blom RSS

    Working SQL Query giving error when run through Qlik (OLEDB Connect32)

    Johan Blom

      I'm trying to pull in some SAP SQL data through the OLEDB Connect 32 connector, but I'm running into an error when it comes to the Business Partner data table generated through a Left Join containing query. My other tables using the same connector work fine and this Query also works fine when run Microsoft SQL Server Management Studio.

       

      QlikError.JPG

      BPMaster:

       

      SQL SELECT OCRD.[GroupCode],

      OCRD.[CardCode],

      OCRD.[CardName],

      OCRD.[SlpCode],

      OCRD.[CardType],

      OCRG.[GroupCode],

      OCRG.[GroupName],

      OSLP.[SlpCode],

      OSLP.[SlpName]

      FROM OCRD

      LEFT JOIN OCRG ON OCRD.[GroupCode] = OCRG.[GroupCode]

      LEFT JOIN OSLP ON OCRD.[SlpCode] = OSLP.[SlpCode];