Comparing 2 tables data

[ggnanaraj]

I have 2 tables A & B, which have to be compared based on a key in both the tables.

Col 1 of Table A should be compared with Col 2 of Table B. So also,
Col 2 of Table A should be compared with Cols 3 and 4 of Table B.

Based on the above comparison, I need to list the number of rows in Table A not present in Table B. Similarly the number of rows in Table B not present in Table A should also be listed.

Can someone help me with this ?

Thanks.

[ggnanaraj]

Thanks. I've completed it, by debugging the code with manageable small sample tables.