数据库有数据，设计器表格预览也显示了，但是运行起来，是啥也没有，这个是我通过试图写的select `t_scdd`.`id` AS `id`,`t_scdd`.`djbh` AS `djbh`,`t_scdd`.`jjbz` AS `jjbz`,`t_scdd`.`xsrq` AS `xsrq`,`t_scdd`.`jhrq` AS `jhrq`,`t_scdd`.`sczt` AS `sczt`,`t_scdd`.`lxr` AS `lxr`,`t_scdd`.`cpmc` AS `cpmc`,`t_scdd`.`tp` AS `tp`,`t_scdd`.`ddsl` AS `ddsl`,`t_scdd`.`scsl` AS `scsl`,`t_scdd`.`rksl` AS `rksl`,`t_scdd`.`cksl` AS `cksl`,`t_scdd`.`kcsl` AS `kcsl`,`t_scdd`.`xsddid` AS `xsddid`,`t_scdd`.`xsddcpxxid` AS `xsddcpxxid`,`t_scdd`.`qtrk` AS `qtrk`,`t_scdd`.`cpid` AS `cpid`,`t_scdd`.`sc` AS `sc`,`t_scdd`.`FGC_CreateDate` AS `FGC_CreateDate`,`t_scdd`.`FGC_LastModifier` AS `FGC_LastModifier`,`t_scdd`.`FGC_LastModifyDate` AS `FGC_LastModifyDate`,`t_scdd`.`FGC_Creator` AS `FGC_Creator`,`t_scdd`.`FGC_UpdateHelp` AS `FGC_UpdateHelp`,`t_scdd`.`FGC_Rowversion` AS `FGC_Rowversion`,ifnull(concat(cast(count((case when ((`v_clxxhz`.`clxs` >= `v_clxxhz`.`sl`) and ((`v_clxxhz`.`wxgx` = `v_clxxhz`.`yjggx`) or (isnull(`v_clxxhz`.`wxgx`) and isnull(`v_clxxhz`.`yjggx`)))) then 1 end)) as char charset utf8mb4),'/',cast(count(distinct `t_clxx`.`id`) as char charset utf8mb4)),'0/0') AS `clqk` from ((`t_scgl_scdd` `t_scdd` left join `t_xsgl_xsdd_clxx` `t_clxx` on((`t_scdd`.`xsddcpxxid` = `t_clxx`.`scid`))) left join `v_scgl_clxxhz` `v_clxxhz` on((`t_clxx`.`id` = `v_clxxhz`.`xsddcldid`))) group by `t_scdd`.`id`视图代码在这里，有没有大佬帮我找找是什么原因
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图
