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;


      oad a,d,c,b_id,dept_id;

      SQL select * from tab1;

      Qualify b_id;

      load f,g,j,kk,

      SQL Select * from tab1;