SELECT a.name, a.phone, group_count(c.item)
FROM 示例数据 a, orderid表 b, item表 c
WHERE b.item = c.id
AND find_in_set(b.id, a.orderid)
GROUP BY 1, 2, 3
评论 (
8
)
引用此答案
SELECT a.name, a.phone, group_concat(c.item) FROM 示例数据 a, orderid表 b, item表 c WHERE b.item = c.id AND find_in_set(b.id, a.orderid) GROUP BY 1, 2