软件开发应该学什么专业_软件开发管理制度_手机如何建网站_免费crm网站不用下载的软件

使用子查询方案查询sql如下
SELECT tab1.*,
( SELECT t5.request_measures FROM hse_control_measures_library_request_measures t5 WHERE t5.laws_id = tab1.tsid AND t5.category_measures = '1296f84b78b333e3e5823a2891ecc36b' ) AS name1,
( SELECT t6.request_measures FROM hse_control_measures_library_request_measures t6 WHERE t6.laws_id = tab1.tsid AND t6.category_measures = '54582f859ab2fd298d372492e91d488e' ) AS name2,
( SELECT t7.request_measures FROM hse_control_measures_library_request_measures t7 WHERE t7.laws_id = tab1.tsid AND t7.category_measures = '6917b74b20bd6d0e33fd019a903cd476' ) AS name3,
( SELECT t8.request_measures FROM hse_control_measures_library_request_measures t8 WHERE t8.laws_id = tab1.tsid AND t8.category_measures = '6b979c59517ae6fd23d96c12185ed1a5' ) AS name4,
( SELECT t9.request_measures FROM hse_control_measures_library_request_measures t9 WHERE t9.laws_id = tab1.tsid AND t9.category_measures = '972096c5ae2b90e82e782802cb5de39b' ) AS name5,
( SELECT t10.request_measures FROM hse_control_measures_library_request_measures t10 WHERE t10.laws_id = tab1.tsid AND t10.category_measures = 'a687369648b132c8d01c781efd7c36e6' ) AS name6
from (
SELECT
t1.id,
t2.id as tsid,
t1.measures_name,
t4.dict_name measures_type,
t3.control_hierarchy
FROM
hse_control_measures_library t1
LEFT JOIN hse_control_measures_library_laws_regulations t2 ON t1.id = t2.library_id
LEFT JOIN hse_control_measures_library_request_measures t3 ON t2.id = t3.laws_id
LEFT JOIN hse_data_dict t4 ON t1.measures_type = t4.id
WHERE
t1.is_deleted = 0 GROUP BY t1.id) as tab1