<!--根据夹具id获取适用实验类型--> <select id="getTestTypeByFixtureId" resultMap="NewResultMap" parameterType="java.lang.String"> SELECT GROUP_CONCAT(DISTINCT(t.name)) as testTypeNames, GROUP_CONCAT(DISTINCT(t.id)) as testTypeIds FROM test_type t INNER JOIN fixture_test_type ft ON t.id = ft.test_type_id AND ft.fixture_id = #{fixture_id} AND t.del_status = 1 </select>
SELECT GROUP_CONCAT(t.url) as urls
FROM tbl_project_attachment t
WHERE t.project_apply_id = 7