Question

我在编程的时候遇到了一个问题，请各位大虾帮忙解决一下

select d.swjg_mc "税务机关名称",a.nsrsbh "纳税人税号",a.nsrmc from dj_nsrxx a,dm_swjg d where nsrzt_dm not in ('50') exists(select 1 from fp_pz b where b.nsrsbh=a.nsrsbh) and not exists(select 1 from fp_gpy c where c.nsrsbh=a.nsrsbh) and a.nsr_swjg_dm=d.swjg_dm order by a.nsr_swjg_dm
这是我编的一个程序，可是运行的时候会出现”数据库不能结束运行”，为什么呀？

Answer 1

没有加结束语句。

Answer 2

select d.swjg_mc as "税务机关名称",a.nsrsbh as "纳税人税号",a.nsrmc from dj_nsrxx a,dm_swjg d where nsrzt_dm not in ('50') exists(select 1 from fp_pz b where b.nsrsbh=a.nsrsbh) and not exists(select 1 from fp_gpy c where c.nsrsbh=a.nsrsbh) and a.nsr_swjg_dm=d.swjg_dm order by a.nsr_swjg_dm