1.sql

来自「行业应急系统 包括: 应急系统（待遇核发） 发放系统 开」· SQL 代码 · 共 41 行

Select 
RYID as "RYID_FF",
ZH as DWID_FF,
'1000000000' as "SSDWID",
XM,
'123456789012345' as "SFZH",
ZS1 as "HDJE",
3 as FFFS,
'10000000000' as "FFJGID",
3 as DJQK,
c2 as DZ,
C3 as YZBM,
ZS1 as "FFJE",
0 as "LJFFJE",
1 as "FFZQ",
1 as "RYZT"
from xf

Select 
RYID as "RYID_FF",
'185' as DWID_FF,
'1000000000' as "SSDWID",
XM,
'123456789012345' as "SFZH",
ZS1 as "HDJE",
3 as FFFS,
'1000000007' as "FFJGID",
3 as DJQK,
c2 as DZ,
C3 as YZBM,
ZS1 as "FFJE",
0 as "LJFFJE",
1 as "FFZQ",
1 as "RYZT"
from kgyf

select * from kgyf

select * from tff_wtffjg
select * from tff_ryxx where ssdwid='1000000000'