删除 跨表删除下面查询条件中查询到的内容，sql语句怎么写：select*from SurveyFeaturePoint_20136,SurveyFe
删除 跨表
删除下面查询条件中查询到的内容，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只能删除一个表