Compare two tables and give the output record which does not exist in 1st
table
I want an SQL code which should perform the task of data scrubbing.
I have two tables both contain some names I want to compare them and list
out only those name which are in table 2 but not in table 1.
Example:
Table 1 = A ,B,C
Table 2 = C,D,E
The result must have D and E?
No comments:
Post a Comment