mysql连接两个字段并进⾏多表联查
SELECT
u.openid,o.user_name,o.student_der_id,o.price,o.payment,c.urse_urses_ach_name,concat_ws('-',o.created_at,o.over_time) as expire_time,c.is_field,o.class_surplus,o.ated_at
FROM
ox_courses_order o
left JOIN ox_user u ON u.id = o.user_id
left join ox_class_history h der_der_id
left join ox_courses c on c.urse_id
left join ox_staff s on s.uch_id
left join ox_courses_type t on t.urses_type_id
left join ox_coach_level a on a.uch_id
mysql下载链接
GROUP der_id

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。