0

merge tables in JDM

Hello,

I have 2 NAV adapter and want to import a table from both NAV into one table in DWH. How can I merge these two tables into one?

There will be duplicates in the tables. I want to get only one, no duplicates.

Table 1:

110002-001
110002-002
110002-004

Table 2:

110002-002
110002-003
110002-004
110002-005

I want in my table:

110002-001
110002-002
110002-003
110002-004
110002-005

 

Thank you
Bianca

2 comments

Please sign in to leave a comment.