方便更快捷的说明问题,可以按需填写(可删除)
使用环境:5.0.0
场景、问题:
分库建为school_code
执行SQL如下:
SELECT
*
FROM
v_diag_obj_subject T142
INNER JOIN dw_diag_obj T80 ON T142.diag_obj_id = T80.diag_obj_id
AND T80.school_code IN ( ‘bjzx’ )
AND T80.school_term_id IN ( ‘2111’ )
INNER JOIN dw_naire_number_answer_obj_avg T137 ON T80.diag_obj_id = T137.diag_obj_id
AND T80.school_code = T137.school_code
AND T80.school_term_id = T137.school_term_id
GROUP BY
T142.subject_id,
T142.subject_name,
T142.subject_show_seq,
T80.show_seq