Combine two or more tables into one

Hi All,

I am quiet new to Jet Enterprise, but not new to BI, and i was wondering if there is a way (other than creating a view on staging) to combine one or more source table into one Destination something like Union (not Union all).

an example:
table A: has the data (One, Two, Three)
Table B: Has the data (Three, Four, Five)

as a result i would like to have only
Table DW (One, Two, Three, Four, Five)…

three must not be repeated.
i created a view and solved my prloblem but as mentioned above, just checking if there is another way.



Please sign in to leave a comment.