如何为MySQL编写查询?

I have two tables as:

我有两张桌子:

mysql> select * from survey;
+-----------+-----------+----------+--------+-----------+
| survey_id | client_id | stage_id | by_ref | no_branch |
+-----------+-----------+----------+--------+-----------+
|         2 |        65 |       72 | P      | 15        |
|         3 |        67 |       72 | D      | 2         |
+-----------+-----------+----------+--------+-----------+
2 rows in set (0.07 sec)

mysql> select * from allcode where code_type="MARKETING_STAGES";
+------------------+---------+------+--------------------+
| code_type        | code_id | srno | code_name          |
+------------------+---------+------+--------------------+
| MARKETING_STAGES |      72 |    1 | Enquiry            |
| MARKETING_STAGES |      73 |    3 | Meeting            |
| MARKETING_STAGES |      74 |    4 | Presentation       |
| MARKETING_STAGES |      75 |    5 | Review / Follow up |
| MARKETING_STAGES |      76 |    6 | Negotiation        |
| MARKETING_STAGES |      77 |    7 | Order              |
| MARKETING_STAGES |      78 |    8 | Agreement          |
| MARKETING_STAGES |     162 |    9 | Complete           |
| MARKETING_STAGES |     163 |    2 | Tender             |
+------------------+---------+------+--------------------+
9 rows in set (0.04 sec)
mysql> selec