【SQL脚本编写经验 - SQL关联删除】

问题概述： 根据删除临时表中的字段（dpt_code & fp_code）去删除表中数据

DELETE FROM first FROM BGT_projects first
INNER JOIN need_delete_temp second
ON first.dpt_code = second.dpt_code AND first.fp_code = second.fp_code
WHERE first.bgt_year = '2023';