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.