CODEWITHSUNDEEP
sqloracle-database
jcthomas113
jcthomas113

Reputation: 412

Using the Minus statement to return result set

I am using Oracle SQL Developer, I need to compare 2 tables and return the result set. The queries are tricky on this one, and I have not been able to come across an example that is similar to what I am trying to accomplish.

I have attempted to create the query below but am not sure how to move forward, as the queries have different number of result columns. Some of the columns are similar but not exact, and I still want the result set to display the records from the first query, as I am just using the second query to make sure there are no duplicates in the table.

I essentially will be asking the user for a number, in this case 15, the first query will return a result set, say of 20 records, I then need to use ORDER from the first query to check in the second query and then return all the records that appeared in the first set but not in the second. 

SELECT MODEL, ORDR, CONSMR, PRODN 
FROM a.Store // db schema
WHERE (MODEL = '15') // No problems on this query

MINUS

SELECT MODEL, ORDR 
FROM newStore 
WHERE ORDR..... // Not sure what should go here

Upvotes: 1

Views: 1251

Answers (1)

Josh Edwards
Josh Edwards

Reputation: 908

You should use a NOT EXISTS. Basically, here's the format:

SELECT <stuff> FROM Table1
WHERE NOT EXISTS 
  (SELECT 1 FROM Table2
   WHERE Table1.Something = Table2.Something)

Upvotes: 5

Related Questions