8 Replies Latest reply: Apr 25, 2017 9:44 AM by Massimo Grossi RSS

    Using one table to filter another

    Eduardo DImperio

      Hi evereybody,

       

      I need some help, cause i want to select some data from RS_INDIVIDUAL_BILLING where OID_METER are in [lib://Dados/MI/Leituras/Consumo/Condominios/Carga_Consolidada_20170424.qvd].

       

      How can i do that?

       

       

      LOAD

      OID_METER

      FROM

      [lib://Dados/MI/Leituras/Consumo/Condominios/Carga_Consolidada_20170424.qvd]

       

       

      RS_INDIVIDUAL_BILLING:

      LOAD

      *

      ;

      SQL

      SELECT

      *

      FROM RS_INDIVIDUAL_BILLING

       

      WHERE MONTH1>='20/04/2017' AND OID_METER = ??????;

       

      Thank you