I need to determine how many instances of "attribute1" exist in "table name1" but not in "table name2."
Essentially, I want the same result as the following query, but with a SET operator.
Code: Select all
[code]SELECT count(distinct <attribute1>) FROM <table_name1> WHERE <attribute1> IS NOT (SELECT <attribute1> FROM <table_name2>);
I've looked through many Oracle manuals and other internet directories but haven't found satisfactory answers; could somebody kindly assist me?