上sql
--1.这样的写法是不行的
-- DELETE A
-- FROM
-- warnbriefreport A
-- LEFT JOIN WarnGeoInfo b ON A .warnid = b.warn_id
-- WHERE
-- b.warn_id = '809'
-- OR b.wg03 = '809'
--2.需要修改成这样的写法
DELETE FROM warnbriefreport
USING warnbriefreport AS ed
LEFT JOIN WarnGeoInfo AS nd ON
ed.warnid = nd.warn_id
WHERE
nd.warn_id = '809'
OR nd.wg03 = '809'