Brandie Tarvin (5/6/2013)
Given what information the OP gave us, that's what he wants.
File 1:
A
B
C
File 2:
E
F
G
Union All gives us:
A
B
C
E
F
G
Merge Join gives us:
A E
B F
C G
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP