I need to write both the cases,

If match found in table A and table B, Then i need to write the output like

Table A ProjNumber Table B ProjNumber IsMatchFound

1234 1234 Y

1234 0000 N

I need to trace for which project numbers, there was no match found..

Please help me out..

Thanks