How can I use a intervalmatch to create a mapping table for all common or uncommon value

[#1]

table 1:

col1:

Value1,

value2,

value3

value5

....

col2:

value2

value3

value4

....

final mapping table should have all of them.

value1,

value2

value3

value5

Can you advise?

[prieper]

I don't quite understand the question. Do you wish to see all values (1,2,3,4,5)? Then you may use JOIN. Otherwise you have repeated same data as in col1.

Peter