急问一个SQL语句

Question

试试这样:
select a.bh_sq, a.zcmc,a.zcly,a.bh_bgy,B.XH,b.sj_cr,b.sj_wc,b.dm_czy from ea_zcxx a,(select max(xh) from ea_lcb group by bh_sq) b where a.bh_sq=b.bh_sq; 

Answer 1

select a.bh_sq, a.zcmc,a.zcly,a.bh_bgy,B.XH,b.sj_cr,b.sj_wc,b.dm_czy from ea_zcxx a,ea_lcb b,( select bh_sq, max(xh) max_xh from ea_lcb group by bh_sq) c where a.bh_sq=b.bh_sq and b.bh_sq=c.bh_sq and b.xh=c.max_xh