一些sql语句

select a._id,a.innerId,(select entpName From android_pucEntp c where c.innerID=a.innerId) entpName,b.checkUnit,c._id troubleId,a.entpTypeId,a.checkItemId,c.improveStep,c.improveUnit,c.finishDate,c.closeFlag,c.checkDate From android_govCheckInspectCheckContent a ,android_insRecord b,android_govtroubleregcheck c where a.inspectID=b._ID  and a._id=c.inspectId
and (c.checkDate>date() or c.finishDate>date() or c.checkDate='')and c.closeFlag is null and improveunit is null and a.innerId=8129         


and (c.checkDate<date() and c.checkDate<>'' and c.closeFlag is null or c.finishDate<date() and c.finishDate<>'' and c.closeFlag is null)  and a.innerId=8129 
and c.finishDate<date() and c.finishDate<>'' and c.closeFlag is null  or c.checkDate<date() and c.checkDate<>'' and c.closeFlag is null


update  android_govTroubleRegCheck set checkdate='2014-05-20' where _id=119


select  improveunit,finishDate,* from android_govTroubleRegCheck where  finishDate>date()
finishDate<date() and finishDate<>'' and closeFlag is null or checkDate<date() and checkDate<>'' and closeFlag is null




select c.savetime,a._id,a.innerId,(select entpName From android_pucEntp c where c.innerID=a.innerId) entpName,b.checkUnit,c._id troubleId,a.entpTypeId,a.checkItemId,c.improveStep,c.improveUnit,c.finishDate,c.closeFlag,c.checkDate,b.assistExecuter from android_govCheckInspectCheckContent a ,android_insRecord b,android_govtroubleregcheck c where 1=1 and a.inspectID=b._ID  and a._id=c.inspectId and a.troubleType=1 and a.innerId=528959 order by c.saveTime desc