有时删除时需要判断多个表中是否有记录,如果存在有记录则不允许删除。
SELECT c=SUM(c) FROM (
SELECT COUNT(1) c FROM SBGL_WXXXB WHERE bxr='999999' or JSR='999999' UNION ALL
SELECT COUNT(1) FROM SBGL_WXXXB_JCB WHERE wxr='999999' OR XZGCS='999999' UNION ALL
SELECT COUNT(1) FROM SBGL_WXXXB_RYB WHERE gkhm='999999' OR ZHXGR='999999'
) t