2 Replies Latest reply: Dec 10, 2013 7:21 PM by Gayathri Nishtala RSS

    How-To: Add Code to your Content


      how to define this condition
      if(tab1.dept_id='global' then tab2.dept_id
      else tab1.dept_id)

       

      in tab1 table, if the script is as below;

       

      Qualify b_id;

      l

      oad a,d,c,b_id,dept_id;

      SQL select * from tab1;


      Qualify b_id;

      load f,g,j,kk,

      b_id,dept_id;
      SQL Select * from tab1;