5 Replies Latest reply: Oct 22, 2011 7:27 AM by Miguel Angel Baeyens de Arce RSS

    How Load tables like SQL minus

      HI experts,

      I need your help ... I need the information than exist one table but doesn't exist to another table..Like the MINUS query at SQL than returns all rows in the first query that are not returned in the second query.

      I write an example:

      Table Store_Information

      store_nameSalesDate
      Los Angeles1500 €05-Jan-1999
      San Diego250 €07-Jan-1999
      Los Angeles300 €08-Jan-1999
      Boston700 €08-Jan-1999


      Table Internet_Sales

      DateSales
      07-Jan-1999250 €
      10-Jan-1999535 €
      11-Jan-1999320 €
      12-Jan-1999750 €


      SELECT Date FROM Store_Information
      MINUS
      SELECT Date FROM Internet_Sales

      Result:

      Date
      05-Jan-1999
      08-Jan-1999