query to select and show data from 2 tables ionic, angular, javascript

Hi someone know how get data from two tables and show in a view??? Please help I try this var query = "SELECT t1.DV_EINDT_ODA, t1.DV_NETPR_WAERS_POS_ODA, t1.DV_MENGE_MEINS_POS_ODA, t1.DV_MATNR_TXZ01_POS_ODA, t1.DV_PEINH_POS, t1.DV_NAMECL_POS_ODA FROM Tabella_OdL t1, Tab_OdL2 t2 WHERE t1.caseFolderId = t2.caseFolderId AND t1.stepName LIKE 'Item details' AND t1.Archiviata = 0 AND t2.Archiviata = 0";

and to show this

**

**div ng-init="goDettaglio();goDettDivDue();selectAllODLC1();">
     <ion-list class="list">
        <ion-item id="dettaglioList" ng-repeat="dettagli in dettaglio" class="wrapword">
        <p>Purchasing Document: </p><p><span class="note2">{{dettagli.DV_EBELN_ODA}}</span></p>

        <p>Creation Date: </p><p><span class="note2">{{dettagli.DateCreated | date :"dd/MM/yyyy"}}</span></p>

        <p>Purchasing Group: </p><p><span class="note2">{{dettagli.DV_EKGRP_EKNAM_ODA}}</span></p>

        <p>Vendor: </p><p><span class="note2">{{dettagli.DV_NAME_ODA}}</span></p>

        <p>Total Valure: </p><p><span class="note2">{{dettagli.DV_NETPR_WAERS_ODA}}</span></p>

        <p>Name Creator: </p><p style="padding-bottom: 10px"><span class="note2">{{dettagli.DV_NAME_CR}}</span></p>
 <!--     </ion-item>
    </ion-list> 
</div>
 -->
  <div class="col" style="font-weight: bold; border-bottom: 1px solid #FF6600;border-top: 1px solid #FF6600;">Posizione 00010</div>
    <div ng-init="goDettDivDue()">
      <ion-list class="list">    
        <ion-item id="dettaglioList" ng-repeat="dettagli in divC1" class="wrapword">     

        <p>Delivery Date: </p><p><span class="note2">{{dettagli.DV_EINDT_ODA}}</span></p>

        <p>Plant: </p><p><span class="note2">{{}}</span></p>

        <p>Net Price: </p><p><span class="note2">{{dettagli.DV_NETPR_WAERS_POS_ODA}}</span></p>

        <p>Quantity: </p><p><span class="note2">{{dettagli.DV_MENGE_MEINS_POS_ODA}}</span></p>

        <p>Material code: </p><p><span class="note2">{{dettagli.DV_MATNR_TXZ01_POS_ODA}}</span></p>
        <p>Unit price: </p><p><span class="note2">{{dettagli.DV_PEINH_POS}}</span></p>
        <p>Delivery address: </p><p><span class="note2">{{dettagli.DV_NAMECL_POS_ODA}}</span></p>

        </ion-item>
      </ion-list> 
    </div>   

        </ion-item>
    /ion-list>       **

**

ionic, angular, javascript