mysql - 合并两个 Mysql 查询

Question

我正在尝试合并两个查询。

$query_1 = mysql_query("SELECT * FROM `table1_results` WHERE id=".$_GET['id']);
while($table1_results = mysql_fetch_assoc($query_1)){
    $total[] = $table1_results;
}

和

$query_1 = mysql_query("SELECT * FROM `table2_results` WHERE id=".$_GET['id']);
while($table2_results = mysql_fetch_assoc($query_1)){
    $total[] = $table2_results;
}

everything remains the same, just I want to combine two different tables

table2_results

and

table2_results in one query

查阅了很多例子，但没有得到想要的结果，请给出一个正确的解决问题的例子谢谢

Answer 1

您应该使用内部联接

  SELECT * FROM `table1_results`  as a
  Inner join `table2_results` as b on a.id = b.id 
  WHERE a.id=".$_GET['id']