A 테이블 

No    |    Name    |  AGE

1              A              21

2              B              21

3              C              22

4              D              23

5              E              23

6              F              25

7              G             26

8              H             27

9              I              27

B 테이블

No    |    Name    |  AGE

1              A              21

2              B              21

3              C              22

두개의 테이블이 있을때 A테이블에 있는 No가 B 테이블에 존재 하면 아래와 같이 결과를 얻고 싶습니다.

결과

No    |    Name    |  AGE    | RESULT

1              A              21             Y

2              B              21             Y

3              C              22             Y

4              D              23             N

5              E              23             N

6              F              25             N

7              G              26             N

8              H              27             N

9              I               27              N

나름 해봤는데... 결과가...ㅠㅠ 12개가 나오질 않나...아니면 딸랑 3개가 나오질 않은가...ㅠㅠ

잘 안되네요..도움 부탁드림니다.