Table "test.member" "test.department" OUTER JOIN句

testdb=# \d member
                       Table "test.member"
 Column  |         Type          | Collation | Nullable | Default 
---------+-----------------------+-----------+----------+---------
 no      | integer               |           |          | 
 name    | text                  |           |          | 
 tel     | character varying(11) |           |          | 
 groupno | integer               |           |          | 

testdb=# \d department
                      Table "test.department"
  Column   |         Type          | Collation | Nullable | Default 
-----------+-----------------------+-----------+----------+---------
 groupno   | integer               |           |          | 
 groupname | text                  |           |          | 
 boss      | text                  |           |          | 
 tel       | character varying(11) |           |          | 

testdb=# SELECT * FROM member;
 no | name |     tel     | groupno 
----+------+-------------+---------
  1 | 石川 | 01201234567 |       2
  2 | 鈴木 | 01201234568 |       3
  3 | 児玉 | 01201234569 |       2
(3 rows)

testdb=# SELECT * FROM department;
 groupno | groupname | boss |     tel     
---------+-----------+------+-------------
       1 | 人事部    | 蜂谷 | 01201234561
       2 | 総務      | 石川 | 01201234567
(2 rows)

testdb=# SELECT * FROM member LEFT OUTER JOIN department USING (groupno);
 groupno | no | name |     tel     | groupname | boss |     tel     
---------+----+------+-------------+-----------+------+-------------
       2 |  1 | 石川 | 01201234567 | 総務      | 石川 | 01201234567
       3 |  2 | 鈴木 | 01201234568 |           |      | 
       2 |  3 | 児玉 | 01201234569 | 総務      | 石川 | 01201234567
(3 rows)