DELETE from dss_dat108 where ID in (
select
A.ID
FROM
dss_dat108 A
LEFT JOIN
dss_bas108 B
ON
B.ID = A.TECHID
WHERE
TECHSTARTDATE > DATEID)
报错 You can't specify target table 'dss_dat108' for update in FROM clause
改成如下 成功
DELETE from dss_dat108 where ID in (
select C.ID from (
select
A.ID
FROM
dss_dat108 A
LEFT JOIN
dss_bas108 B
ON
B.ID = A.TECHID
WHERE
TECHSTARTDATE > DATEID)C)
hanah0310
commented
4 years ago
DELETE from dss_dat108 where ID in ( select A.ID FROM dss_dat108 A LEFT JOIN dss_bas108 B ON B.ID = A.TECHID WHERE TECHSTARTDATE > DATEID)
报错 You can't specify target table 'dss_dat108' for update in FROM clause
改成如下 成功 DELETE from dss_dat108 where ID in ( select C.ID from ( select A.ID FROM dss_dat108 A LEFT JOIN dss_bas108 B ON B.ID = A.TECHID WHERE TECHSTARTDATE > DATEID)C)