SELECT O1.DEPARTMENTNAME AS SGDW, F1.HZDW, F1.BD, F1.ZBDWS, F2.ZBDWMC, F2.FFCCDH, F2.SBXH, COALESCE(F3.RYXX, F4.RYXX) AS RYXX, COALESCE(F3.SFZ, F4.ZJBH) AS IDENTIFIER FROM BO_EU_HZDWZBQKTJ F1 LEFT JOIN BO_EU_LJ_SCGL_HZDWZBDW F2 ON F1.BINDID = F2.BINDID LEFT JOIN BO_EU_1744263114403 F3 ON F2.ID = F3.BINDID LEFT JOIN BO_EU_1743487430920 F4 ON F2.ID = F4.BINDID LEFT JOIN ORGDEPARTMENT O1 ON F1.SGDW = O1.ID 以上这段sql在 navicat 中可以执行,在帆软中无法执行,报错同义词转换不在有效 只有这张表无法查询,同一个数据库中的其他表都可以查询 |