mysql - 如何 LEFT JOIN 具有相同列名的两个表

Question

我想 LEFT JOIN 具有相同列名的两个表。我有两个表，我正在尝试加入，但我一直收到错误消息:

column 'id' is ambiguous

在我的 JSON 输出中返回。

我当前的查询:

$sQuery = "
 SELECT SQL_CALC_FOUND_ROWS ".str_replace(" , ", " ", implode(", ", $aColumns))."
 FROM   $sTable
 LEFT JOIN
    $sTable2
    ON ($sTable2.id = $sTable.id)

 $sWhere
 $sOrder
 $sLimit
";

产生那个错误。两张表有相同的列名时，如何将这两个表作为连接点连接？

Answer 1

明确列属于哪个表。这也适用于查询的 SELECT 部分:

SELECT table1.column AS column1, table2.column AS column2
FROM table1
LEFT JOIN table2
ON table1.column = table2.column

为节省您的打字时间，请使用表别名:

SELECT t1.column AS column1, t2.column AS column2
FROM table1 AS t1
LEFT JOIN table2 AS t2
ON t1.column = t2.column