-- MYSQL 5.1
SELECT
oi.order_sn, oi.order_time, re.region_name,
oi.order_amount_exchange, oi.coupon_code, oi.from_domain,
GROUP_CONCAT(
CAST
(og.goods_id
AS CHAR
))
AS
goods_id
FROM
order_info oi
LEFT JOIN
order_goods og
ON
oi.order_id = og.order_id
LEFT JOIN
region re
ON
oi.country = re.region_id
WHERE
oi.coupon_code
IN
("FAN10", "UKFAN10")
GROUP BY
oi.order_sn;
-- MYSQL 5.5
SELECT
oi.order_sn, oi.order_time, re.region_name,
oi.order_amount_exchange, oi.coupon_code, oi.from_domain,
GROUP_CONCAT(og.goods_id)
AS
goods_id
FROM
order_info oi
LEFT JOIN
order_goods og
ON
oi.order_id = og.order_id
LEFT JOIN
region re
ON
oi.country = re.region_id
WHERE
oi.coupon_code
IN
("FAN10", "UKFAN10")
GROUP BY
order_sn;
mysql group_concat 在 5.1版本中需要将字段类型由int类型改成字符串类型