遠藤です。

yasushi fujiwara さんは書きました:
>はじめまして、「やすし」と申します。

% mysql test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 3.23.41-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table a ( cd char(10) );
Query OK, 0 rows affected (0.11 sec)

mysql> create table e ( cd char(10), name char(20));
Query OK, 0 rows affected (0.09 sec)

mysql> insert into a values ('1');
Query OK, 1 row affected (0.00 sec)

mysql> insert into e values ('1', '長島 茂雄');
Query OK, 1 row affected (0.00 sec)

mysql> insert into e values ('２', '鈴木 一郎');
Query OK, 1 row affected (0.00 sec)

mysql> select * from a;
+------+
| cd   |
+------+
| 1    |
+------+
1 row in set (0.00 sec)

mysql> select * from e;
+------+-----------+
| cd   | name      |
+------+-----------+
| 1    | 長島 茂雄 |
| ２   | 鈴木 一郎 |
+------+-----------+
2 rows in set (0.00 sec)

mysql> select distinct e.cd, e.name from e, a where e.cd <> a.cd;
+------+-----------+
| cd   | name      |
+------+-----------+
| ２   | 鈴木 一郎 |
+------+-----------+
1 row in set (0.01 sec)