2 Replies Latest reply: Sep 12, 2013 8:17 AM by Oleg German RSS

    Extract difference-Oracle Minus operation.

      Hi guys,

      here i have a task- i want to get a difference between two tables in the third table. For example, if the table m1 contains rows: 2005,2006,2007,2008 and the table m2 contains: 2005, then the table m3 must contain:2006,2007,2008.

       

      I've got the script which loads the first and the second tables:

       

      m1:

        Load *;

        sql

        select distinct year(orderdate) as sqlyearlist

        from AdventureWorks2012.Sales."vSalesOrderHeader-July"

        order by 1 asc;

      m2:

        LOAD  Distinct   year(OrderDate) as qvdyearlist

           FROM Orders_*.QVD (qvd);

       

      Appreciate any advises and solutions.