php - 如何在mysql中连接两列与连接表

Question

我有两个表 issue_details 和 payees 如下所示，其值如下:

表:issue_details

+----------+------------+----------+----------+
| check_no | issue_date | payee_id | lddap_no | 
+----------+------------+----------+----------+
|        0 | 2015-01-01 |          | 11101-15 | 
|        1 | 2015-01-24 |          | 11101-15 |
|    34561 | 2015-01-24 | 10       |          |
|    34562 | 2015-01-24 | 13       |          | 
+----------+------------+----------+----------+

表:收款人

+----------+--------------------+
| payee_id | payee_name         | 
+----------+--------------------+
| 1        | John Smith         | 
| 10       | Chen Lou           | 
| 11       | Mark Dello         |
| 12       | ANTRECCO           | 
| 13       | Shay Ridz          | 
+----------+--------------------+

我执行此查询以连接两个表以描述我的 issue_details 表中的收款人姓名。

SELECT      
    issue_details.issue_date AS date,
    issue_details.check_no AS check_no,
    payees.payee_name AS payee 
FROM
    issue_details
INNER JOIN 
    payees ON issue_details.payee_id = payees.payee_id

结果:

+----------+------------+----------+
| check_no | issue_date | payee    | 
+----------+------------+----------+
|    34561 | 2015-01-24 | Chen Lou |       
|    34562 | 2015-01-24 | Shay Ridz|       
+----------+------------+----------+

如果我这样做:

SELECT      
    issue_details.issue_date AS date,
    issue_details.check_no AS check_no,
    CONCAT(payees.payee_name, '', lddap_no) AS payee 
FROM
    issue_details
INNER JOIN 
    payees ON issue_details.payee_id = payees.payee_id

结果还是和上面一样。它不连接两列payee_name(从表 payees 加入)和 lddap_no。

这是我想要发生的事情:

+----------+------------+----------+
| check_no | issue_date | payee    |  
+----------+------------+----------+
|        0 | 2015-01-01 | 11101-15 |      
|        1 | 2015-01-24 | 11101-15 |     
|    34561 | 2015-01-24 | Chen Lou |
|    34562 | 2015-01-24 | Shay Ridz|     
+----------+------------+----------+

请在这里帮助我查询。将不胜感激。谢谢

Answer 1

只需将 INNER JOIN 更改为 LEFT JOIN

SELECT      issue_details.issue_date AS date,
            issue_details.check_no AS check_no,
            payees.payee_name AS payee 
FROM
            issue_details
            LEFT JOIN payees ON
            issue_details.payee_id = payees.payee_id