select a.sbrq from a,
(select jh, lch, max(b.gzd) gzd from b group by lch,jh) d,
(select lch, max(c.gzd) gzd from c group by lch) e
where a.jh=d.jh
and d.lch=e.lch
and d.gzd=e.gzd
(select jh, lch, max(b.gzd) gzd from b group by lch,jh) d,
(select lch, max(c.gzd) gzd from c group by lch) e
where a.jh=d.jh
and d.lch=e.lch
and d.gzd=e.gzd
bbb as (select c.lch as lch2,max(c.gzh) as gzh2 from c,aaa where c.lch = aaa.lch1 and c.gzh = aaa.gzh1 group by c.lch)
select a.sbrq
from a,b,bbb
where a.jh = b.jh and
b.lch = bbb.lch2 and
b.gzh = bbb.gzh2