sql= "select ph from(select a.ph,a.jshj,a.ZLHJ ,b.JSHJ as JSHJ9,b.ZLHJ as ZLHJ9,b.TJHJ as TJHJ9,b.YFHJ as YFHJ9,b.YSHJ as YSHJ9, b.yishj as yishj9, b.HDFF as HDFF9, b.HZFF as HZFF9, b.DSHK as DSHK9, b.DFHK as DFHK9, b.DFYF as DFYF9, b.BXJE as BXJE9, b.BXF as BXF9, b.SHF as SHF9, b.QTDF as QTDF9,b.THF as THF9 from (from MbLog where bj='已发未改') a left join ( from MbLog where bj='已发删除' ) b on a.PH=b.PH)";
如果不行、就CreateSqlQuery这样!!!