2 Replies Latest reply: May 7, 2014 12:48 PM by Patricia Gabardo RSS

    Save qvd

    Patricia Gabardo

      I have a list of 197 tables and I need to compare the different records.
      I'm using the command


      TbA:
      (select col_a, col_b, col_c
         from tab_1
      union all
      select col_a, col_b, col_c
         from tab_2)
      minus
      (select col_a, col_b, col_c
         from tab_1
      intersect
      select col_a, col_b, col_c
         from tab_2)


      TbB:
      (select col_a, col_b, col_c
         from tab_3
      union all
      select col_a, col_b, col_c
         from tab_4)
      minus
      (select col_a, col_b, col_c
         from tab_3
      intersect
      select col_a, col_b, col_c
         from tab_4)

      etc...

      When recording the QVD want it saved just Tb have different records, in the amount of TBA records read is 0 QVD not save ...
      Can anyone help?