sql 的问题 急急急！！！

[xiaocaokan]

请教大家一个问题：下面的sql语句
select * from(select * from (select a.id_nsr,a.name_nsr,a.id_wjdm,b.name_dmmc from(d_swdjb a left join md_nsrzt b on a.id_nsrzt = b.id_nsrzt)) ab left join
(select c.id_nsr, c.glfl_ms,c.glfl_jdlb,c.dljg_name_dljg,c.dljg_name_fzr,c.dljg_addr,c.dljg_lxfs,c.dljg_dlfw,c.nsxydj_snd,c.id_lzszsfs,c.id_sdszsfs,c.id_sbfs,c.id_jsfs,c.id_glle from sgys_swdjbcxx c) ac on ab.id_nsr=ac.id_nsr) abc
left join(select * from(select * from (select id_nsr, name_nsr as name1,tel as tel1,mobile as shouji1,s_mobile as xiaolintong1 from sgys_swdjbcxx_ry where id_rylx='05' ) ad left join
(select id_nsr,name_nsr as name2,tel as tel2,mobile as shouji2,s_mobile as xiaolintong2 from sgys_swdjbcxx_ry where id_rylx='06' ) ae on ad.id_nsr=ae.id_nsr ) aed left join
(select id_nsr,name_nsr as name3,tel as tel3,mobile as shouji3,s_mobile as xiaolintong3 from sgys_swdjbcxx_ry where id_rylx='07' ) af on aed.id_nsr=af.id_nsr) aedf on abc.id_nsr=aedf.id_nsr where abc.id_wjdm='2406683';
在pb中没有问题
但在jbuilder中说找不到 abc 表
为什么啊
哪位知道帮忙解释一下
先谢了

[ehai0991]

你的连接驱动是不是有问题?

[miaoliujun]

如果PB中可以那JB中也应该可以，因为这个和IDE的关系是一点也没有的。

首先你用一个简单的SQL语句看看，数据库有没有连通，比如select * from abc;

如果这个都不能执行你就得分析，是不是数据库还没有连上。
如果能执行，你可以把这个SQL语句直接在数据库上执行，看看是不是数据库做了修改引起的。