4 Replies Latest reply: Aug 25, 2017 1:35 AM by amir jabbar RSS

    how to write script in data modeling for sub query and tree

    amir jabbar

      Hello Everyone,

                            i have a question , i m writing a query which have sub query and tree , i want to write in qlike sence data modeling ,

      fallowing are the query script

       

      WHERE MST.VNO=DTL.VNO

      AND DTL.ACID=COA.ID

      AND ID IN (SELECT ID FROM NGL_COA START WITH ID='20000000' CONNECT BY PRIOR ID=PACID)