라이믹스 쿼리문의 세계 - 서브쿼리 작성 예제

경로

modules/nstore/queries/getstocksubquery.xml

 

코드

<query id="getstocksubquery" action="select">
   <tables>
      <table name="nstore_stock_log" alias="stock" />                 
   </tables>
   <columns>        
      <column name="stock.item_srl" />
      <column name="stock.location" />        
       <query id="getstock1data" alias="stock">
            <tables>
                <table name="nstore_stock_log" alias="stock_log" />
            </tables>
            <columns>
                <column name="stock" alias="stock" />
            </columns>
            <conditions>
                <condition operation="equal" column="stock_log.item_srl" default="stock.item_srl" />
            <condition operation="equal" column="stock_log.location" default="stock.location" pipe="and" />
            </conditions>
           <navigation>
            <index var="sort_index" default="stock_log.stock_log_srl" order="desc" />     
            <list_count var="list_count" default="1" />                         
            </navigation>
        </query>
   </columns> 
   <groups>
        <group column="stock.item_srl" />    
      <group column="stock.location" />         
    </groups>       
</query>

설명