Merging Unique emails from 2 tables
Posted: Sun Aug 31, 2008 9:49 am
Hi community,
I have Table 1 and Table2 both having unique emails within them.
Table 1 being the main email Container, I want INTERSECTION of Table 1 and Table2 and the UNIQUE emails between the two should be moved to Table 1.
So now that Table 1 should have All the Unique Emails within itself and also between Table 1 and Table2
ex
Table 1
A
B
C
D
Table 2
F
G
I
B
C
So finally Table 1 should have
A
B
C
D
F
G
I
Note: values B and C already exist in Table 1 and should be ignored.
How to write this query?
I have Table 1 and Table2 both having unique emails within them.
Table 1 being the main email Container, I want INTERSECTION of Table 1 and Table2 and the UNIQUE emails between the two should be moved to Table 1.
So now that Table 1 should have All the Unique Emails within itself and also between Table 1 and Table2
ex
Table 1
A
B
C
D
Table 2
F
G
I
B
C
So finally Table 1 should have
A
B
C
D
F
G
I
Note: values B and C already exist in Table 1 and should be ignored.
How to write this query?