多表查询，主表一个字段，附表多个字段，主表一条信息对应一个附表列表，要求附表固定字段按照固定的拼接方式显示

多表查询，主表一个字段，附表多个字段，主表一条信息对应一个附表列表，要求附表固定字段按照固定的拼接方式显示，如图
sql如下
SELECT
o.out_order_code,
IFNULL(
(SELECT GROUP_CONCAT(IFNULL(transport.tel, ‘-’) SEPARATOR ‘/’) FROM global_order_transport transport WHERE transport.order_no = o.out_order_code),
‘-’
) AS tel,
IFNULL(
(SELECT GROUP_CONCAT(IFNULL(transport.driver_name, ‘-’) SEPARATOR ‘/’) FROM global_order_transport transport WHERE transport.order_no = o.out_order_code),
‘-’
) AS driverName,
IFNULL(
(SELECT GROUP_CONCAT(IFNULL(transport.transport_code, ‘-’ ) SEPARATOR ‘/’) FROM global_order_transport transport WHERE transport.order_no = o.out_order_code),
‘-’
) AS transportCode
FROM
wms_order_out o
ORDER BY o.create_time DESC