Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008

    Unanswered: Subtracting a subset of a table

    Hi. Using Hyperion Client for Oracle I am having trouble with the following issue:

    I have a master table of data. In a separate table I have a subset of the master data. I would like to create a new table that contains the entries on the master that do NOT appear on the subset table. I want to subtract the subset from the master and be left with a new table.

    in terms of a join it might be something like:

    Table 1 contains the master
    Table 2 contains a subset of the master
    JOIN: Retrieve all rows where joined columns do NOT match

    Anyone have any thoughts on this?

    Many thanks.

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL

    Talking Minus

    Check out the MINUS set operator.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts