删除 跨表
删除下面查询条件中查询到的内容,sql语句怎么写:
select *from SurveyFeaturePoint_20136,SurveyFeature
where SurveyFeaturePoint_20136.SurveyFeatureID = SurveyFeature.SurveyFeatureID and
charindex('20',Longitude) > 0 or charindex('39',Latitude)> 0
[解决办法]
delete SurveyFeaturePoint_20136
from SurveyFeaturePoint_20136,SurveyFeature
where SurveyFeaturePoint_20136.SurveyFeatureID = SurveyFeature.SurveyFeatureID and
charindex('20',Longitude) > 0 or charindex('39',Latitude)> 0
[解决办法]
每次DELETE只能删除一个表