请教select 子查询的sql语句

Question

desc tb_oa_staff;
+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| staffid         | char(20)     | NO   | PRI | NULL    |       |
| orgid           | char(20)     | NO   |     | NULL    |       |
| staffname       | char(20)     | NO   |     | NULL    |       |
| sex             | char(1)      | YES  |     | NULL    |       |
| age             | int(11)      | YES  |     | NULL    |       |
| national        | varchar(100) | YES  |     | NULL    |       |
| birthday        | date         | YES  |     | NULL    |       |
| certno          | varchar(30)  | YES  |     | NULL    |       |
| political       | char(20)     | YES  |     | NULL    |       |
| maritalstatus   | char(1)      | YES  |     | NULL    |       |
| accountlocation | varchar(200) | YES  |     | NULL    |       |
| currentaddress  | varchar(200) | YES  |     | NULL    |       |
| telephone       | varchar(20)  | YES  |     | NULL    |       |
| emergencyphone  | varchar(20)  | YES  |     | NULL    |       |
| optrid          | varchar(20)  | YES  |     | NULL    |       |
| opttime         | datetime     | YES  |     | NULL    |       |
| re          | varchar(100) | YES  |     | NULL    |       |
+-----------------+--------------+------+-----+---------+-------+
17 rows in set
desc tb_oa_organization;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| orgid    | char(20)     | NO   | PRI | NULL    |       |
| orgcode  | char(100)    | NO   |     | NULL    |       |
| parentid | char(20)     | NO   |     | NULL    |       |
| status   | char(1)      | YES  |     | NULL    |       |
| optrid   | varchar(20)  | YES  |     | NULL    |       |
| opttime  | datetime     | YES  |     | NULL    |       |
| re   | varchar(100) | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+
7 rows in set
我想把tb_oa_staff表里的全部记录都查出来 顺便根据查出来的orgid 把 tb_oa_organization里的orgcode也查出来
能不能用select 子查询弄出来？

Answer 1

SELECT s.*,o.orgcode 
FROM tb_oa_staff s LEFT JOIN tb_oa_organization o
ON s.orgid=o.orgid;

Answer 2

select a.staffid ,a.orgid,a.staffname,a.sex ,a.age ,a.national ,a.birthday ,a.certno,b.orgcode from tb_oa_staff a join tb_oa_organization b ON b.orgid=a.orgid;