本人SQL语句不是很会今天工作遇到一个多表连接优化的问题, 优化下边的SQL语句
select cl.*,BASEXX.MINGC,BASEXX.PIZWH,BASEXX.SHENGCCJ from (select * from (select CHELDJXX.*,LXRXX.XINGM from CHELDJXX,LXRXX where CHELDJXX.ZHIDR_ID=LXRXX.ID) h join CHELDJMX on h.ID=CHELDJMX.CHELDJ_ID) cl join BASEXX on cl.BASEXX_ID=BASEXX.ID
请大家帮帮忙啊!! 感激不尽