Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Non Matching Values

DaveyBJul 6 2008 — edited Jul 8 2008
Dear All,

I have two tables tableA and tableB each containing a random multiset of data.
TableA
Name
David
Mike
John

TableB
Name
James
David
Mike

What I want to know is all the values that are NOT in BOTH tableA and tableB. In this situation it would be the Names John and James.

Any ideas?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 5 2008
Added on Jul 6 2008
10 comments
5,454 views