mysql 조인이요.!죄송해요 자꾸 질문해서.

mysql> select *,
    -> (select count(*)
    -> from id2
    -> where nation=nation) from id;
+------+---------+--------+------------------------------------------------+
| NUM  | ID_NAME | NATION | (select count(*)
from id2
where nation=nation) |
+------+---------+--------+------------------------------------------------+
|    1 | kim     | korea  |                                              4 |
|    2 | park    | jappan |                                              4 |
|    2 | hong    | china  |                                              4 |
|    3 | yang    | spain  |                                              4 |
+------+---------+--------+------------------------------------------------+
4 rows in set (0.05 sec)

mysql> select * from id;
+------+---------+--------+
| NUM  | ID_NAME | NATION |
+------+---------+--------+
|    1 | kim     | korea  |
|    2 | park    | jappan |
|    2 | hong    | china  |
|    3 | yang    | spain  |
+------+---------+--------+
4 rows in set (0.00 sec)

mysql> select * from id2;
+------+------+--------+
| sub  | juso | NATION |
+------+------+--------+
| kor  | kkk  | korea  |
| eng  | jjj  | hoko   |
| mat  | ooo  | china  |
| mat  | ooo  | usa    |
+------+------+--------+
4 rows in set (0.00 sec)

id 라는 테이블과 id2라는 테이블에서 nation이 같은 걸 출력하는데.
같은건 korea,china이렇게 있으면 두개가 출력되야하는것 아닌가요?
출력결과가 이해가 안가는데,,답변좀해주세요.

mysql>