7 Replies Latest reply: Apr 20, 2018 3:17 PM by Eduardo DImperio RSS

    Oracle Select with Qlik Sense Exists()

    Eduardo DImperio

      Hi,

       

      I have a table in qlik sense and i need to do a select in a sql table, but only when OID_SYSTEM_AGUA (Qlik Sense) = OID_SYSTEM (SQL).

       

      AGUA:

      Load

      DISTINCT

      OID_SYSTEM_AGUA,

      NAME_TYPE_METER_AGUA,

      QTDE_MED_AGUA

      Resident TOTAL_AGUA;

       

       

      RS_INDIVIDUAL_BILLING:

      LOAD

      *

      ;

      SQL

      SELECT

      OID_SYSTEM

      FROM RS_INDIVIDUAL_BILLING

      WHERE ???????