CUCU2/src/custom/restcontroller/webmanage/saletool/courseware/SQL/我的考试列表.sql

SELECT
    t1.sat_courseware_testheadid,
    t1.title,
    t1.num,
    t2.sat_courseware_testid,
    t2.status,
    t2.score,
    t2.answercount
FROM
    sat_courseware_testhead t1
left join  sat_courseware_test t2 on t2.sat_courseware_testheadid=t1.sat_courseware_testheadid and t2.siteid=t1.siteid


where $where$ and t1.status = '发布'   and t1.siteid = $siteid$ and t1.sat_courseware_testheadid IN
                                                                    (
                                                                        SELECT sat_courseware_testheadid FROM sat_courseware_testauth WHERE
                                                                            departmentid IN $departmentid$  OR hrid IN  $hrid$ OR sys_enterpriseid IN  $sys_enterpriseid$ OR sa_saleareaid IN  $sa_saleareaid$ or roleid in $roleid$
    )