根据列加入MySql

Question

我希望从Report和终端表中选择行来创建这样的行：

+----+-------------------+---------------------+---------+-------+--------+-----+---------+------+
| id | mac_adresi        | zaman               | fabrika | kumes | makina | kat | sol_sag | adet |
+----+-------------------+---------------------+---------+-------+--------+-----+---------+------+
|  3 | 97-F9-2C-55-19-72 | 2017-11-18 22:43:29 | Çorum2  | Ana2  | 22     | 12  | So2     | 213  |
+----+-------------------+---------------------+---------+-------+--------+-----+---------+------+

报表表；

+----+-------------------+------+---------------------+
| id | mac_adresi        | adet | zaman               |
+----+-------------------+------+---------------------+
|  3 | 97-F9-2C-55-19-72 | 213  | 2017-11-18 22:43:29 |
+----+-------------------+------+---------------------+

终端表；

+----+-------------------+---------+-------+--------+-----+---------+
| id | mac_adresi        | fabrika | kumes | makina | kat | sol_sag |
+----+-------------------+---------+-------+--------+-----+---------+
| 86 | 97-F9-2C-55-19-72 | Çorum2  | Ana2  | 22     | 12  | So2     |
+----+-------------------+---------+-------+--------+-----+---------+

在终端表中，mac_adresi是主键，

在Report表中，mac_adresi是外键。

我已经尝试过这个查询，但是结果不是我想要实现的。

SELECT report.*,terminal.fabrika,terminal.kumes,terminal.makina,terminal.kat,terminal.sol_sag FROM report JOIN terminal ORDER BY id DESC limit 10

我该怎么做？

Answer 1

您应该设置联接的ON子句。

SELECT 
      report.*
      ,terminal.fabrika
      ,terminal.kumes
      ,terminal.makina
      ,terminal.kat
      ,terminal.sol_sag 
FROM report JOIN terminal on  report.mac_adresi = Terminal.mac_adresi   
ORDER BY id DESC limit 10