Trying to implement (<=) cardinality in framwork manager

[smtest]

hi,
i am trying to create a less than equal cardinality in framework manager. But i am getting full outer join issue.

This is how the data looks:
Department                   Department1
100000                            100000
100001                            100001
100002                            100002
                                           100003
                                          100004

But because of full outer join, i am getting 3 * 5 =15 rows

all i am trying to achieve is when
department1 = 100003, then i will get in department (100002)
department1 = 100004, then i will get in department (100002)
department1 = 100002, then i will get in department (100002)

please advice

[blom0344]

Aren't you confusing full outer join with a cross join?  A cross join would yield  3x5 combinations
A  <= join would fetch  3+3+3+1+1 =  11 combinations