目前,当我使用joins时,cust_base中的每一行都有3行数据。(由于cust_addition_value表中有3个值)。我希望多行数据成为一个逗号分隔值的单行。
代码如下:
$statement = $pdo->prepare("SELECT
cust_base.field1,cust_base.field2,cust_addition_value.field3
FROM cust_base INNER JOIN cust_addition_value on cust_base.id=cust_addition_value.cid");
$statement->execute();
$data1 =$statement->fetchAll();发布于 2021-07-05 18:23:09
使用GROUP BY和GROUP_CONCAT
SELECT
cust_base.field1,cust_base.field2,GROUP_CONCAT(cust_addition_value.field3)
FROM cust_base INNER JOIN cust_addition_value on cust_base.id=cust_addition_value.cid
GROUP BY cust_base.field1,cust_base.field2https://stackoverflow.com/questions/68254408
复制相似问题