Skip to Content
0

How to union the 2 data base

Aug 15, 2017 at 08:26 AM

18

avatar image

Hi ,

I want to create union data source.

how can I do?

DS 1 : 1,2,3,4,5,6

DS 2 : 1,3,5,7,8,9

Union data Source : 1,2,3,4,5,6,7,8,9

If I used inner join , the result was : 1,3,5

If I used left outer join , the result was : 1,2,3,4,5,6

If I combine the 2 DS, the result was : 1,1,2,3,3,4,5,5,6,7,8,9

So, how can I do to get the result 1,2,3,4,5,6,7,8,9 .

Best Regards,

Pole

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers