sql

(
        SELECT DISTINCT tml.id FROM sys_user su,sys_user_role sur,sys_role_b srb,trp_mst_laboratory tml,sys_role_function srf
        WHERE su.user_id = sur.user_id AND sur.role_id = srb.role_id AND srf.role_id = srb.role_id
        AND  srb.attribute1 = tml.lab_code  AND su.user_id = #{userId} AND srf.function_id = #{functionId}
        )

sql

标签：from   use   sele   class   tor   role   where   HERE   func