查询用字段.sql

行业应急系统 包括: 应急系统（待遇核发） 发放系统 开发环境:Delphi5 (sp1)+ Oracle 8.05 MultiExport是一个可以将数据按指定字段倒出

--
--	加入社会化发放查询的字段信息
--	2000-11-16 9:49
--
ALTER TABLE tsysfield ADD tablename VARCHAR2(50)
/
ALTER TABLE tsysfield ADD joincond VARCHAR2(1000)
/
ALTER TABLE tsysfield ADD aliastable VARCHAR2(50)
/

INSERT INTO tSYSTable(ID,TABLENAME,COMMENTS)
VALUES('1001','FF_DWXX','发放单位')
/
INSERT INTO tSYSTable(ID,TABLENAME,COMMENTS)
VALUES('1002','FF_RYXX','发放人员')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100101,1001,'DWID_FF',0,'','String,'单位序号','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100102,1001,'SSDWID',0,'','String,'所属单位','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100103,1001,'DWDM',1,'','String,'单位代码','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100104,1001,'DWMC',1,'','String,'单位名称','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100105,1001,'DMMC',1,'select dmmc as Value from tdmb where zdbz=''SSHY''','String,'所属行业',
'tdmb','tff_dwxx.sshy=dm_sshy.dm and dm_sshy.zdbz=''SSHY''','dm_sshy')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100106,1001,'FRDB',1,'','String,'法人代表','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100107,1001,'DWJBR',1,'','String,'单位经办人','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100108,1001,'ZH',1,'','String,'帐户','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100109,1001,'KHMC',1,'','String,'开户行','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100110,1001,'YZBM',1,'','String,'邮政编码','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100111,1001,'DWDZ',1,'','String,'单位地址','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100112,1001,'LXDH',1,'','String,'联系电话','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100113,1001,'SHHFFSJ',1,'','Date  ,'社会化发放时间','tff_dwxx','','tff_dwxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100201,1002,'RYID_FF',0,'','String,'人员标识','tff_ryxx','','tff_ryxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100202,1002,'DWDM',1,'','String,'组代码','tff_dwxx','dw_zdm.dwid_ff=tff_ryxx.dwid_ff','dw_zdm')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100203,1002,'DWMC',1,'','String,'单位名称','tff_dwxx','dw_dwmc.dwid_ff=tff_ryxx.ssdwid',
'dw_dwmc')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100204,1002,'XM',1,'','String,'姓名','tff_ryxx','','tff_ryxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100205,1002,'SFZH',1,'','String,'身份证号','tff_ryxx','','tff_ryxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100206,1002,'HDJE',1,'','String,'核定金额','tff_ryxx','','tff_ryxx')
/
INSERT INTO tFF_RYXX
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(100207,1002,'DMMC',1,'select dmmc as Value from tdmb where zdbz=''FFXS''','String,'发放方式',
'tDMB','tff_ryxx.fffs=dm_fffs.dm and dm_fffs.zdbz=''FFXS''','dm_fffs')
/