select
s.id,
s.case_no,
s.case_no_new,
s.name caseName,
to_char(s.create_date,'yyyy-mm-dd') create_date,
dd.cbr1 as realName,
s.registrant,
to_char(s.update_date,'yyyy-mm-dd') update_date,
dd."notice",
s."type",
case
when cur_major = 0 then 10
when cur_major != 0 then cur_major
end cur_major
from t_netpolice_case s
LEFT JOIN t_netpolice_user u
on s.registrant = u.id
left join (
select c."id", sf."value" AS cbr1,nf.notice
from "t_netpolice_case" c,
"t_netpolice_step" as s,
"t_netpolice_step_field" as sf,
t_netpolice_case_new_field as nf
WHERE c."id" = s."case_id"
and c."id" = nf."case_id"
and s."id" = sf."step_id"
and s."del_flag" = '0'
and sf."name" = 'field201'
AND s."major"='10'
AND s."minor"='10'
AND s."del_flag"=0
union all
select c."id", u.realname as cbr1, nf.notice
from "t_netpolice_case" c
left join "t_netpolice_step" as s on c."id" = s."case_id"
left join t_netpolice_user as u on c."create_user" = u.id
left join t_netpolice_case_new_field as nf on c."id" = nf."case_id"
WHERE
s."case_id" is null
AND c."del_flag"= 0
) as dd on dd."id"= s."id"
where s.del_flag = 0
and s.finish_flag = 0
这个是sql语句