Hello,

thanks for your hint, but it's not working the way I need it.
because the amount of values in the table1 is not always the same...sometimes there are 3, 5, or 7 values or more in a single row...


--------
Table1:
--------
1 mon1 mon2 mon5 mon2 mon1
2 mon1 mon2 mon3 mon4 mon6 mon1 mon2 mon1
3 mon1 mon5 mon1



---------
Table2: |
----------
1 mon1 mon2
1 mon2 mon5
1 mon5 mon2
1 mon2 mon1

2 mon1 mon2
2 mon2 mon3
2 mon3 mon4
2 mon4 mon6
2 mon6 mon2
2 mon2 mon1



then the union command does not work...

any other suggestions...
Thx...
Petra.