Help with Data Model

[sjaiswal13]

I have 2 tables A and B.

Table A has many columns 1,2 3........

Table B has many columns 1,2,c.......

i want to first find all matching as well non matching rows based on column 1 that is outer join on that. For all the resulting column 1 , i want to match column 2 for all those rows.

  Composite key is not working as desired.

A
aa	bb	cc	dd	ee
1	a
2	b
2	c
4	j

B
aa	bb	x	y	z
1	a
2	b
2	c
2	d

Thanks