如何从两个表中查询? [英] how to query from two tables?

问题描述

我有两张桌子:

1. 表temp_hsl"

<前>|id|kota_a||41|1 ||42|2 |

2. 表 'jarak kota'

<前>|id|kota_a|kota_b |贾拉克||1 |1 |1 |0 ||2 |1 |2 |2 ||3 |1 |3 |3 ||4 |2 |1 |2 ||5 |2 |2 |0 ||6 |2 |3 |3 ||7 |3 |1 |3 ||8 |3 |2 |3 ||9 |3 |3 |0 |

我想要最终结果:

<前>|id|kota_a|kota_b |贾拉克||1 |1 |1 |0 ||2 |1 |2 |2 ||3 |2 |1 |2 ||4 |2 |2 |0 |

上面的结果基于带有表 temp_hsl 的关系表.如何使用命令mysql?我试过了，但查询循环的结果还在继续.

解决方案

使用这个，如果你不再次编辑你的问题，只需编辑@Ashmik 的答案应该可以正常工作.

<块引用>

SELECT A.id, A.kota_a, A.kota_b, A.jarak FROM jarak_kota A INNER JOINtemp_hsl B ON A.kota_a = B.kota_a LIMIT 0 , 30

I have two table:

1. Table 'temp_hsl'

|id|kota_a|  
|41| 1    |
|42| 2    |

2. Table 'jarak kota'

|id|kota_a|kota_b | jarak|
|1 |1     |1      | 0    |
|2 |1     |2      | 2    |
|3 |1     |3      | 3    |
|4 |2     |1      | 2    |
|5 |2     |2      | 0    |
|6 |2     |3      | 3    |
|7 |3     |1      | 3    |
|8 |3     |2      | 3    |
|9 |3     |3      | 0    |

I want end result:

|id|kota_a|kota_b | jarak|
|1 |1     |1      | 0    |
|2 |1     |2      | 2    |
|3 |2     |1      | 2    |
|4 |2     |2      | 0    |

The result above is based on a relation table with table temp_hsl. How do it with command mysql? I 've tried , but the results of its query looping continues.

解决方案

Use this, just edit @Ashmik's answer should work fine if you don't edit your question again.

SELECT A.id, A.kota_a, A.kota_b, A.jarak FROM jarak_kota A INNER JOIN temp_hsl B ON A.kota_a = B.kota_a LIMIT 0 , 30

这篇关于如何从两个表中查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！