SELECT
T.x zqh_code administrative districts encoding,
T.x zqh_name the name of the administrative area,
Annual, t.y Lin ear
T.d w_code unit coding,
T.d w_name unit name,
T.X M_CODE project coding,
T.x m_name project name,
The sum (budget_money) AS indicators of amount
The FROM
CZ_GK_YSZBB t
LEFT the JOIN CZ_BM_JJFLB jj ON t.y Lin ear=jj. Year
AND t.x zqh_code=jj. Xzqh_code
AND t.j jkm_code=jj. Jjkm_code
WHERE
T.x zqh_code='33'
AND dw_name NOT LIKE '% % points mouth indicators'
AND jj. Jjkm_fullname NOT LIKE '% % between higher AND lower government metastatic spending'
GROUP BY
T.x zqh_code, t.x zqh_name, t.y Lin ear,
Dw_code, t.d w_name, t.X M_CODE, t.X m_name



After an SQL query above query results but in the delete statement is executed after successful cross line
In the table CZ_BM_JJFLB jjkm_fullname NOT according to the condition LIKE '% % between higher and lower government metastatic spending after the query is shown
hope which bosses can help to reassure

CodePudding user response:

Guess is conditions of conflict, you can try after delete query underlined sentence out whether there is a whole table does not contain the ' ' 'metastatic between higher and lower government spending