select exp_act, t.*
from exp
left join (select * FROM crosstab(
'select expcheck_expid, expcheck_clsid, expcheck_clsid from expcheck where expcheck_clsid in(1017,1018,1019,1020,1021,1022,1024,1025,1026,1027,1028)'::text,
'select distinct expcheck_clsid from expcheck where expcheck_clsid in(1017,1018,1019,1020,1021,1022,1024,1025,1026,1027,1028) order by expcheck_clsid'::text)
crosstab(exp_lab_expid integer, f1017 integer, f1018 integer, f1019 integer, f1020 integer, f1021 integer, f1022 integer, f1024 integer, f1025 integer, f1026 integer, f1027 integer, f1028 integer)
) t on t.exp_lab_expid=exp.exp_id
where (exp.exp_typeid = 2) and (((exp_datestart)>='01.01.2017') And ((exp_datestart)<='31.05.2017')) and (not exp_statusid=5) and exp_id=791402
order by exp_act

CREATE OR REPLACE VIEW view_check AS 
 SELECT expcheck_expid,expcheck_clsid from expcheck group by expcheck_expid,expcheck_clsid

select t.*
from exp
left join (
select distinct  * FROM crosstab(
'select expcheck_expid, expcheck_clsid, expcheck_clsid from view_check where expcheck_clsid in(1017,1018,1019,1020,1021,1022,1024,1025,1026,1027,1028) '::text,
'select distinct expcheck_clsid from view_check where expcheck_clsid in(1017,1018,1019,1020,1021,1022,1024,1025,1026,1027,1028) order by expcheck_clsid'::text)
crosstab(exp_lab_expid integer, f1017 integer, f1018 integer, f1019 integer, f1020 integer, f1021 integer, 
f1022 integer, f1024 integer, f1025 integer, f1026 integer, f1027 integer, f1028 integer)
) t on t.exp_lab_expid=exp.exp_id
where (exp.exp_typeid = 2) and (((exp_datestart)>='01.01.2017') And ((exp_datestart)<='31.05.2017')) and (not exp_statusid=5)
and exp_id=791402