insert into table_name( A ) values (SELECT F_GET() FROM D WHERE X)
insert into table_name(a) values(select f_get() from d where x)
select f_getwsffsfcc(f.sfzcc,f.sfzdm,f.zdzdm,g.sfzcc,g.sfzdm,g.zdzdm) from tmp_fsfcc f,tmp_fsfcc where f.ny=cs_ny and g.ny=cs_ny and f.sfzdm=g.zdzdm and f.zdzdm=g.sfzdm;又说 缺少表达式 晕了
谢谢原因 找到了 insert into to_lcjbxx(lcjbxx_wsfcc)(
select f_getwsffsfcc(f.sfzcc,f.sfzdm,f.zdzdm,g.sfzcc,g.sfzdm,g.zdzdm) from tmp_fsfcc f,tmp_fsfcc g where f.ny=cs_ny and g.ny=cs_ny and f.sfzdm=g.zdzdm and f.zdzdm=g.sfzdm );--语句错了 缺少 别名 g 给大家添麻烦了,太粗心了
values (SELECT F_GET() FROM D WHERE X)
values(select f_get() from d where x)
select f_getwsffsfcc(f.sfzcc,f.sfzdm,f.zdzdm,g.sfzcc,g.sfzdm,g.zdzdm) from tmp_fsfcc f,tmp_fsfcc where f.ny=cs_ny and g.ny=cs_ny and f.sfzdm=g.zdzdm and f.zdzdm=g.sfzdm;又说 缺少表达式 晕了
select f_getwsffsfcc(f.sfzcc,f.sfzdm,f.zdzdm,g.sfzcc,g.sfzdm,g.zdzdm)
from tmp_fsfcc f,tmp_fsfcc g
where f.ny=cs_ny and g.ny=cs_ny and f.sfzdm=g.zdzdm and f.zdzdm=g.sfzdm
);--语句错了 缺少 别名 g 给大家添麻烦了,太粗心了