Full Outer join with merge

dsrules · Post by **dsrules** » Thu Jul 31, 2008 5:54 pm

Hi
I was trying to do a full outer join using merge stage (server edition) , but I dont see any option that says full outer join .I tried the complete set option but it just behaved like an inner join .

How can we get full outer join with merge stage ,

Thank you

chulett · Post by **chulett** » Thu Jul 31, 2008 6:07 pm

Technically, there is no "full outer join" option in the Merge stage. From what I understand, the closest you can come is the Complete Set and it is more of a "union all" than a join of any kind.