|
RecordsCombined
数据库中的多行记录的数据合并问题.
简介数据库中的多行记录的数据合并为一行。 转换思路,根据实际积分数据规律来设计流程。尽量简化访问数据库次数,提高运行效率。 1,主卡数据比较多,则生成表来进行再处理。 2,付卡数据较少,大概是主卡的1/100 3,第二、三、四付卡数据更少,大概是主卡的1/10000 所以采取以下处理流程: 1,主卡和第一付卡数据生成表 2,其他付卡数据使用ADO方式搜索并写入对应的主卡记录中。 20080515经实践发现ACCESS作为数据库外部IO访问效率不好,尤其在.mdb文件上G时慢如蜗牛。所以完全放弃,不用VB连ADO访问ACCESS了,把SQL全部写入ACCESS查询,并通过查询生成表来分流计算负荷。 采取以下处理流程: 1,主卡和第一、二、三、四付卡数据均生成表 2,通过以下查询和表实现: 贷记卡付卡积分2 贷记卡付卡积分3 贷记卡付卡积分4 gen贷记卡积分第三付卡 gen贷记卡积分第二付卡 gen贷记卡积分第一付卡 贷记卡积分第三付卡 贷记卡积分第二付卡 贷记卡积分第一付卡 贷记卡积分其余付卡-->gen贷记卡积分其余付卡2 gen贷记卡积分其余付卡3 gen贷记卡积分其余付卡4 贷记卡付卡积分2 贷记卡付卡积分3 贷记卡付卡积分4 gen准贷记卡积分第三付卡 gen准贷记卡积分第二付卡 gen准贷记卡积分第一付卡 准贷记卡积分第三付卡 准贷记卡积分第二付卡 准贷记卡积分第一付卡 准贷记卡积分其余付卡-->gen准贷记卡积分其余付卡2 gen准贷记卡积分其余付卡3 gen准贷记卡积分其余付卡4 准贷记卡付卡积分2 准贷记卡付卡积分3 准贷记卡付卡积分4 参见参考资料:
20080515改进工作流程备忘20080515 1,贷记卡合计 --> gen贷记卡合计 贷记卡最后余额 --> gen贷记卡最后余额 贷记卡类型 --> gen贷记卡类型 准贷记卡合计 --> gen准贷记卡合计 准贷记卡最后余额 --> gen准贷记卡最后余额 准贷记卡类型 --> gen准贷记卡类型 2,大错误:BN_BFHDZDZZ剔除账号和主卡号的重复匹配(由于币种不同而引起), 如:积分信息中有重复数据,四月份有17个,属于第一付卡的有十个。所以第一份付卡有2273,但删除付卡有2283 要彻底查一下所有和BN_BFHDZDZZ有关的查询和表 gen贷记卡汇总表 gen贷记卡付卡积分 gen准贷记卡汇总表 gen准贷记卡付卡积分 解决方法:除了账号以外再加入一个关联主键:币种 3, 贷记卡付卡积分2 贷记卡付卡积分3 贷记卡付卡积分4 gen贷记卡积分第三付卡 gen贷记卡积分第二付卡 gen贷记卡积分第一付卡 贷记卡积分第三付卡 贷记卡积分第二付卡 贷记卡积分第一付卡 贷记卡积分其余付卡-->gen贷记卡积分其余付卡2 gen贷记卡积分其余付卡3 gen贷记卡积分其余付卡4 贷记卡付卡积分2 贷记卡付卡积分3 贷记卡付卡积分4 gen准贷记卡积分第三付卡 gen准贷记卡积分第二付卡 gen准贷记卡积分第一付卡 准贷记卡积分第三付卡 准贷记卡积分第二付卡 准贷记卡积分第一付卡 准贷记卡积分其余付卡-->gen准贷记卡积分其余付卡2 gen准贷记卡积分其余付卡3 gen准贷记卡积分其余付卡4 准贷记卡付卡积分2 准贷记卡付卡积分3 准贷记卡付卡积分4 4, 可以运行,但很慢且结果异常,放弃 UPDATE 贷记卡付卡积分 SET 贷记卡付卡积分.已处理 = '1' WHERE (dlookup("[卡号]","[贷记卡付卡积分]","[贷记卡付卡积分].[卡号] = '" & [卡号] & "'" ) is not null); 5,删除的过渡的查询备份 20080515删除的过度查询:gen贷记卡帐户信息 INSERT INTO 贷记卡帐户信息 ( 地区号, 账号, 卡号, 邮编, 地址, 单位名称, 姓名, 上月余额, 到期还款日, 最低还款额, 核定信用额度 ) SELECT DISTINCT BN_BFHDZDZZ.地区号, BN_BFHDZDZZ.账号, BN_BFHDZDZZ.主卡卡号 AS 卡号, BN_BFHDZDZZ.邮编, BN_BFHDZDZZ.主卡对账单寄往地址 AS 地址, BN_BFHDZDZZ.单位名称, BN_BFHDZDZZ.收信人姓名 AS 姓名, Format([对账单最后打印余额],"##0.00") AS 上月余额, BN_BFHDZDZZ.到期还款日, BN_BFHDZDZZ.最低还款额, BN_BFHDZDZZ.核定信用额度 FROM BN_BFHDZDZZ; 20080515删除的过度查询:贷记卡明细表1 SELECT BN_BFHDZDZM.帐号 AS ZH, BN_BFHDZDZM.卡号 AS KH, BN_BFHDZDZM.交易日期 AS JYRQ, BN_BFHDZDZM.入账日期 AS RZRQ, BN_BFHDZDZM.交易描述 AS JYLX, BN_BFHDZDZM.交易场所 AS JYDD, BC_MoneyType.币种 AS JYBZ, Format([交易金额],'##0.00') AS JYJE, Format(IIf([借贷标志]='2',[交易金额],''),'##0.00') AS ZR, Format(IIf([借贷标志]='1',[交易金额],''),'##0.00') AS ZC FROM BN_BFHDZDZM LEFT JOIN BC_MoneyType ON BN_BFHDZDZM.交易币种 = BC_MoneyType.币种编码; 20080515删除的过度查询:贷记卡汇总表1 SELECT BN_BFHDZDZZ.地区号 AS DQH, BN_BFHDZDZZ.账号 AS ZH, BN_BFHDZDZZ.主卡卡号 AS KH, BN_BFHDZDZZ.邮编 AS YZBM, BN_BFHDZDZZ.主卡对账单寄往地址 AS DZ, BN_BFHDZDZZ.单位名称 AS DWMC, BN_BFHDZDZZ.收信人姓名 AS NAME, BC_MoneyType.币种 AS BIZ, Format([对账单最后打印余额],"##0.00") AS SYYE, IIf(BYYE>=0,'',Format(BYYE,"##0.00")) AS BQYH, 贷记卡最后余额.最后余额 AS BYYE, Format([收入合计1],"##0.00") AS SRHJ, Format([付出合计1],"##0.00") AS ZCHJ, BN_BFHDZDZZ.到期还款日 AS DQHKR, BN_BFHDZDZZ.最低还款额 AS ZDHKE, BN_BFHDZDZZ.核定信用额度 AS HDXYED, BN_BFHDZDZC.全部消费积分 AS YBJF, BN_BFHDZDZC.卡号联名积分 AS LMJF, BN_BFHDZDZC.特定消费积分 AS TDJF, 贷记卡类型.卡类, BN_PFCZDZC.本期综合贡献积分余额 AS 综合积分余额, IIf([贷记卡类型]![卡类]='个人卡',[特定活动1积分余额],[特定活动1积分余额]+[特定活动2积分余额]+[特定活动3积分余额]) AS 特定1或123积分, IIf([贷记卡类型]![卡类]='个人卡',[特定活动2积分余额],[特定活动4积分余额]+[特定活动5积分余额]+[特定活动6积分余额]) AS 特定2或456积分, IIf([贷记卡类型]![卡类]='个人卡',[特定活动3积分余额],[联名积分余额]) AS 特定3或联名积分, IIf([贷记卡类型]![卡类]='个人卡',[特定活动4积分余额],[当期综合贡献积分]) AS 特定4或新增综合, IIf([贷记卡类型]![卡类]='个人卡',[特定活动5积分余额],[当期特定活动1积分]+[当期特定活动2积分]+[当期特定活动3积分]) AS 特定5或新增123, IIf([贷记卡类型]![卡类]='个人卡',[特定活动6积分余额],[当期特定活动4积分]+[当期特定活动5积分]+[当期特定活动6积分]) AS 特定6或新增456, IIf([贷记卡类型]![卡类]='个人卡',[当期综合贡献积分],[当期联名积分]) AS 新增综合或新增联名, BN_PFCZDZC.当期特定活动2积分 AS 新增信用卡积分, BN_PFCZDZC.当期特定活动5积分 AS 新增特定活动5积分, BN_PFCZDZC.当期联名积分 AS 新增联名积分 FROM (((贷记卡合计 LEFT JOIN ((BN_BFHDZDZZ LEFT JOIN BN_BFHDZDZC ON BN_BFHDZDZZ.主卡卡号 = BN_BFHDZDZC.卡号) LEFT JOIN BC_MoneyType ON BN_BFHDZDZZ.账户币种 = BC_MoneyType.币种编码) ON 贷记卡合计.帐号 = BN_BFHDZDZZ.账号) LEFT JOIN 贷记卡最后余额 ON 贷记卡合计.帐号 = 贷记卡最后余额.帐号) LEFT JOIN BN_PFCZDZC ON BN_BFHDZDZZ.主卡卡号 = BN_PFCZDZC.卡号) LEFT JOIN 贷记卡类型 ON BN_BFHDZDZZ.主卡卡号 = 贷记卡类型.卡号 WHERE (((BN_BFHDZDZZ.主卡对账单寄往地址) Is Not Null)) OR (((BN_BFHDZDZZ.单位名称) Is Not Null)); 20080515删除的过度查询:for贷记卡汇总统计 SELECT BN_BFHDZDZZ.地区号, BN_BFHDZDZZ.账号, BN_BFHDZDZZ.主卡卡号 AS 卡号, BN_BFHDZDZZ.邮编, BN_BFHDZDZZ.主卡对账单寄往地址 AS 地址, BN_BFHDZDZZ.单位名称, BN_BFHDZDZZ.收信人姓名 AS 姓名, BC_MoneyType.币种, Format([对账单最后打印余额],"##0.00") AS 上月余额, IIf([本月余额]>=0,'',Format([本月余额],"##0.00")) AS 本月应还款, 贷记卡最后余额.最后余额 AS 本月余额, Format([收入合计1],"##0.00") AS 收入合计, Format([付出合计1],"##0.00") AS 支出合计, BN_BFHDZDZZ.到期还款日, BN_BFHDZDZZ.最低还款额, BN_BFHDZDZZ.核定信用额度, BN_BFHDZDZC.全部消费积分, BN_BFHDZDZC.卡号联名积分, BN_BFHDZDZC.特定消费积分 FROM (贷记卡合计 LEFT JOIN ((BN_BFHDZDZZ LEFT JOIN BN_BFHDZDZC ON BN_BFHDZDZZ.主卡卡号 = BN_BFHDZDZC.卡号) LEFT JOIN BC_MoneyType ON BN_BFHDZDZZ.账户币种 = BC_MoneyType.币种编码) ON 贷记卡合计.帐号 = BN_BFHDZDZZ.账号) LEFT JOIN 贷记卡最后余额 ON 贷记卡合计.帐号 = 贷记卡最后余额.帐号 WHERE (((BN_BFHDZDZZ.主卡对账单寄往地址) Is Not Null)) OR (((BN_BFHDZDZZ.单位名称) Is Not Null)); 20080515删除的过度查询:for贷记卡明细统计 SELECT BN_BFHDZDZM.帐号, BN_BFHDZDZM.卡号, BN_BFHDZDZM.交易日期, BN_BFHDZDZM.入账日期, BN_BFHDZDZM.交易描述, BN_BFHDZDZM.交易场所, BC_MoneyType.币种, Format([交易金额],'##0.00') AS 金额, Format(IIf([借贷标志]='2',[交易金额],''),'##0.00') AS 收入, Format(IIf([借贷标志]='1',[交易金额],''),'##0.00') AS 支出 FROM BN_BFHDZDZM LEFT JOIN BC_MoneyType ON BN_BFHDZDZM.交易币种 = BC_MoneyType.币种编码; 20080515删除的过度查询:for准贷记卡汇总统计 SELECT BN_BFHFTDZZ.地区号, BN_BFHFTDZZ.帐号, BN_BFHFTDZZ.主卡卡号 AS 卡号, BN_BFHFTDZZ.邮编, BN_BFHFTDZZ.主卡对帐单寄往地址 AS 地址, BN_BFHFTDZZ.单位名称, BN_BFHFTDZZ.主卡持卡人姓名 AS 姓名, Format([收入合计1],"##0.00") AS 收入合计, Format([付出合计1],"##0.00") AS 付出合计, 准贷记卡最后余额.最后余额 AS 本月余额, BN_BFHFTDZZ.对帐单最后打印余额 AS 上月余额, IIf([本月余额]>=0,'',[到期还款日]) AS 到期还款日期, BN_BFHFTDZZ.最低还款额, BN_BFHFTDZZ.超限金额, BN_BFHFTDZZ.贷款利息, BN_BFHFTDZZ.可用信用限额 FROM (准贷记卡合计 LEFT JOIN BN_BFHFTDZZ ON 准贷记卡合计.帐号 = BN_BFHFTDZZ.帐号) LEFT JOIN 准贷记卡最后余额 ON 准贷记卡合计.帐号 = 准贷记卡最后余额.帐号 WHERE (((BN_BFHFTDZZ.主卡对帐单寄往地址) Is Not Null)) OR (((BN_BFHFTDZZ.单位名称) Is Not Null)); 20080515删除的过度查询:for准贷记卡明细统计 SELECT BN_BFHFTDZM.帐号, BN_BFHFTDZM.卡号, BN_BFHFTDZM.交易日期, BN_BFHFTDZM.交易描述, BN_BFHFTDZM.交易场所, Format(IIf([借贷标志]='2',[交易金额],''),'##0.00') AS 收入, Format(IIf([借贷标志]='1',[交易金额],''),'##0.00') AS 支出, Format([更新后余额],'##0.00') AS 余额 FROM BN_BFHFTDZM; 20080515删除的过度查询:贷记卡付卡积分 查询 SELECT DISTINCT 贷记卡付卡积分.主卡卡号, 贷记卡付卡积分.主副卡标志, 贷记卡付卡积分.卡号, 贷记卡付卡积分.联名积分余额, 贷记卡付卡积分.本卡本月新增综合积分, 贷记卡付卡积分.新增信用卡积分, 贷记卡付卡积分.新增特定活动5积分, 贷记卡付卡积分.新增联名积分, 贷记卡付卡积分.已处理 FROM 贷记卡付卡积分; 20080515删除的过度查询:准贷记卡汇总表1 SELECT BN_BFHFTDZZ.地区号 AS DQH, BN_BFHFTDZZ.帐号 AS ZH, BN_BFHFTDZZ.主卡卡号 AS MACARDNO, BN_BFHFTDZZ.邮编 AS POSTNO, BN_BFHFTDZZ.主卡对帐单寄往地址 AS MCACCADDR, BN_BFHFTDZZ.单位名称 AS UNITNAME, BN_BFHFTDZZ.主卡持卡人姓名 AS MCOWNNAM, Format([收入合计1],"##0.00") AS SRHJ, Format([付出合计1],"##0.00") AS FCHJ, 准贷记卡最后余额.最后余额 AS BACCPRBAL, BN_BFHFTDZZ.对帐单最后打印余额 AS ACCPRBAL, IIf(BACCPRBAL>=0,'',[到期还款日]) AS DQHKR, BN_BFHFTDZZ.最低还款额 AS LETPAAMT, BN_BFHFTDZZ.超限金额 AS EXLIAMT, BN_BFHFTDZZ.贷款利息 AS CRINITAMT, BN_BFHFTDZZ.可用信用限额 AS USECREDIT, 准贷记卡类型.卡类 AS 表达式1, BN_PFCZDZC.本期综合贡献积分余额 AS 综合积分余额, BN_PFCZDZC.特定活动1积分余额 AS 特定1积分, BN_PFCZDZC.特定活动2积分余额 AS 特定2积分, BN_PFCZDZC.特定活动3积分余额 AS 特定3积分, BN_PFCZDZC.特定活动4积分余额 AS 特定4积分, BN_PFCZDZC.特定活动5积分余额 AS 特定5积分, BN_PFCZDZC.特定活动6积分余额 AS 特定6积分, BN_PFCZDZC.当期综合贡献积分 AS 新增综合积分, BN_PFCZDZC.当期特定活动2积分 AS 新增信用卡积分, BN_PFCZDZC.当期特定活动5积分 AS 新增特定活动5积分, BN_PFCZDZC.当期联名积分 AS 新增联名积分 FROM 准贷记卡最后余额, 准贷记卡合计, 准贷记卡类型, BN_BFHFTDZZ LEFT JOIN BN_PFCZDZC ON BN_BFHFTDZZ.主卡卡号 = BN_PFCZDZC.卡号 WHERE (((BN_BFHFTDZZ.主卡对帐单寄往地址) Is Not Null)) OR (((BN_BFHFTDZZ.单位名称) Is Not Null)); 20080515删除的过度查询:准贷记卡明细表1 SELECT BN_BFHFTDZM.帐号 AS ZH, BN_BFHFTDZM.卡号 AS MDCARDNO, BN_BFHFTDZM.交易日期 AS BUSIDATE, BN_BFHFTDZM.交易描述 AS TRXCHNS, BN_BFHFTDZM.交易场所 AS TRXSITE, Format(IIf([借贷标志]='2',[交易金额],''),'##0.00') AS LIQUAMT, Format(IIf([借贷标志]='1',[交易金额],''),'##0.00') AS FLIQUAMT, Format([更新后余额],'##0.00') AS LSTBAL FROM BN_BFHFTDZM; 6, 查询1:提取测试的16个卡号 SELECT 贷记卡汇总表FULL., 贷记卡汇总表FULL.卡号 AS 表达式1 FROM 贷记卡汇总表FULL WHERE ((([贷记卡汇总表FULL].[卡号])="4518106801100597" Or ([贷记卡汇总表FULL].[卡号])="4580716801100802" Or ([贷记卡汇总表FULL].[卡号])="4580668018221337" Or ([贷记卡汇总表FULL].[卡号])="6222106801001748" Or ([贷记卡汇总表FULL].[卡号])="6222306802077677" Or ([贷记卡汇总表FULL].[卡号])="6222316801331173" Or ([贷记卡汇总表FULL].[卡号])="6222306802103879" Or ([贷记卡汇总表FULL].[卡号])="6282886801002013" Or ([贷记卡汇总表FULL].[卡号])="6222306801000043" Or ([贷记卡汇总表FULL].[卡号])="6222306801000035" Or ([贷记卡汇总表FULL].[卡号])="6222306801000019" Or ([贷记卡汇总表FULL].[卡号])="6222306801292061" Or ([贷记卡汇总表FULL].[卡号])="6222306801207879" Or ([贷记卡汇总表FULL].[卡号])="6222306801132788" Or ([贷记卡汇总表FULL].[卡号])="6222306801139874" Or ([贷记卡汇总表FULL].[卡号])="6222306801123787" Or ([贷记卡汇总表FULL].[卡号])="6222306801000043" Or ([贷记卡汇总表FULL].[卡号])="6222306801207853" Or ([贷记卡汇总表FULL].[卡号])="6222306801139833" Or ([贷记卡汇总表FULL].[卡号])="6222306801123746")); 查询2: SELECT 贷记卡付卡积分FULL., 贷记卡付卡积分FULL.主卡卡号 AS 表达式1, 贷记卡付卡积分FULL.卡号 AS 表达式2 FROM 贷记卡付卡积分FULL WHERE ((([贷记卡付卡积分FULL].[卡号])="4518106801100597" Or ([贷记卡付卡积分FULL].[卡号])="4580716801100802" Or ([贷记卡付卡积分FULL].[卡号])="4580668018221337" Or ([贷记卡付卡积分FULL].[卡号])="6222106801001748" Or ([贷记卡付卡积分FULL].[卡号])="6222306802077677" Or ([贷记卡付卡积分FULL].[卡号])="6222316801331173" Or ([贷记卡付卡积分FULL].[卡号])="6222306802103879" Or ([贷记卡付卡积分FULL].[卡号])="6282886801002013" Or ([贷记卡付卡积分FULL].[卡号])="6222306801000043" Or ([贷记卡付卡积分FULL].[卡号])="6222306801000035" Or ([贷记卡付卡积分FULL].[卡号])="6222306801000019" Or ([贷记卡付卡积分FULL].[卡号])="6222306801292061" Or ([贷记卡付卡积分FULL].[卡号])="6222306801207879" Or ([贷记卡付卡积分FULL].[卡号])="6222306801132788" Or ([贷记卡付卡积分FULL].[卡号])="6222306801139874" Or ([贷记卡付卡积分FULL].[卡号])="6222306801123787" Or ([贷记卡付卡积分FULL].[卡号])="6222306801000043" Or ([贷记卡付卡积分FULL].[卡号])="6222306801207853" Or ([贷记卡付卡积分FULL].[卡号])="6222306801139833" Or ([贷记卡付卡积分FULL].[卡号])="6222306801123746")) OR ((([贷记卡付卡积分FULL].[主卡卡号])="4518106801100597" Or ([贷记卡付卡积分FULL].[主卡卡号])="4580716801100802" Or ([贷记卡付卡积分FULL].[主卡卡号])="4580668018221337" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222106801001748" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306802077677" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222316801331173" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306802103879" Or ([贷记卡付卡积分FULL].[主卡卡号])="6282886801002013" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801000043" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801000035" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801000019" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801292061" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801207879" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801132788" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801139874" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801123787" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801000043" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801207853" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801139833" Or ([贷记卡付卡积分FULL].[主卡卡号])="6222306801123746")); 查询3: SELECT 准贷记卡汇总表FULL., 准贷记卡汇总表FULL.卡号 AS 表达式1 FROM 准贷记卡汇总表FULL WHERE ((([准贷记卡汇总表FULL].[卡号])="4518106801100597" Or ([准贷记卡汇总表FULL].[卡号])="4580716801100802" Or ([准贷记卡汇总表FULL].[卡号])="4580668018221337" Or ([准贷记卡汇总表FULL].[卡号])="6222106801001748" Or ([准贷记卡汇总表FULL].[卡号])="6222306802077677" Or ([准贷记卡汇总表FULL].[卡号])="6222316801331173" Or ([准贷记卡汇总表FULL].[卡号])="6222306802103879" Or ([准贷记卡汇总表FULL].[卡号])="6282886801002013" Or ([准贷记卡汇总表FULL].[卡号])="6222306801000043" Or ([准贷记卡汇总表FULL].[卡号])="6222306801000035" Or ([准贷记卡汇总表FULL].[卡号])="6222306801000019" Or ([准贷记卡汇总表FULL].[卡号])="6222306801292061" Or ([准贷记卡汇总表FULL].[卡号])="6222306801207879" Or ([准贷记卡汇总表FULL].[卡号])="6222306801132788" Or ([准贷记卡汇总表FULL].[卡号])="6222306801139874" Or ([准贷记卡汇总表FULL].[卡号])="6222306801123787" Or ([准贷记卡汇总表FULL].[卡号])="6222306801000043" Or ([准贷记卡汇总表FULL].[卡号])="6222306801207853" Or ([准贷记卡汇总表FULL].[卡号])="6222306801139833" Or ([准贷记卡汇总表FULL].[卡号])="6222306801123746")); 查询4: SELECT 准贷记卡付卡积分FULL., 准贷记卡付卡积分FULL.主卡卡号 AS 表达式1, 准贷记卡付卡积分FULL.卡号 AS 表达式2 FROM 准贷记卡付卡积分FULL WHERE ((([准贷记卡付卡积分FULL].[卡号])="4518106801100597" Or ([准贷记卡付卡积分FULL].[卡号])="4580716801100802" Or ([准贷记卡付卡积分FULL].[卡号])="4580668018221337" Or ([准贷记卡付卡积分FULL].[卡号])="6222106801001748" Or ([准贷记卡付卡积分FULL].[卡号])="6222306802077677" Or ([准贷记卡付卡积分FULL].[卡号])="6222316801331173" Or ([准贷记卡付卡积分FULL].[卡号])="6222306802103879" Or ([准贷记卡付卡积分FULL].[卡号])="6282886801002013" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801000043" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801000035" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801000019" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801292061" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801207879" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801132788" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801139874" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801123787" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801000043" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801207853" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801139833" Or ([准贷记卡付卡积分FULL].[卡号])="6222306801123746")) OR ((([准贷记卡付卡积分FULL].[主卡卡号])="4518106801100597" Or ([准贷记卡付卡积分FULL].[主卡卡号])="4580716801100802" Or ([准贷记卡付卡积分FULL].[主卡卡号])="4580668018221337" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222106801001748" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306802077677" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222316801331173" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306802103879" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6282886801002013" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801000043" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801000035" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801000019" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801292061" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801207879" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801132788" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801139874" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801123787" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801000043" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801207853" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801139833" Or ([准贷记卡付卡积分FULL].[主卡卡号])="6222306801123746")); 查询5: SELECT 贷记卡明细表FULL., 贷记卡明细表FULL.帐号 AS 表达式1 FROM 贷记卡明细表FULL WHERE ((([贷记卡明细表FULL].[帐号])="19010150210002418" Or ([贷记卡明细表FULL].[帐号])="19010150210020487" Or ([贷记卡明细表FULL].[帐号])="19010150210036722" Or ([贷记卡明细表FULL].[帐号])="19010150210036724" Or ([贷记卡明细表FULL].[帐号])="19010150210036725" Or ([贷记卡明细表FULL].[帐号])="19010150210043550" Or ([贷记卡明细表FULL].[帐号])="19010150210050281" Or ([贷记卡明细表FULL].[帐号])="19010150210088365" Or ([贷记卡明细表FULL].[帐号])="19010150210098375" Or ([贷记卡明细表FULL].[帐号])="19010150210130849" Or ([贷记卡明细表FULL].[帐号])="19010150210036725" Or ([贷记卡明细表FULL].[帐号])="19010150210046721" Or ([贷记卡明细表FULL].[帐号])="19010150210043892" Or ([贷记卡明细表FULL].[帐号])="19010150210043146" Or ([贷记卡明细表FULL].[帐号])="19010150220047195" Or ([贷记卡明细表FULL].[帐号])="19010150220055741")); 查询6: SELECT 准贷记卡明细表FULL., 准贷记卡明细表FULL.帐号 AS 表达式1 FROM 准贷记卡明细表FULL WHERE ((([准贷记卡明细表FULL].[帐号])="19010150210002418" Or ([准贷记卡明细表FULL].[帐号])="19010150210020487" Or ([准贷记卡明细表FULL].[帐号])="19010150210036722" Or ([准贷记卡明细表FULL].[帐号])="19010150210036724" Or ([准贷记卡明细表FULL].[帐号])="19010150210036725" Or ([准贷记卡明细表FULL].[帐号])="19010150210043550" Or ([准贷记卡明细表FULL].[帐号])="19010150210050281" Or ([准贷记卡明细表FULL].[帐号])="19010150210088365" Or ([准贷记卡明细表FULL].[帐号])="19010150210098375" Or ([准贷记卡明细表FULL].[帐号])="19010150210130849" Or ([准贷记卡明细表FULL].[帐号])="19010150210036725" Or ([准贷记卡明细表FULL].[帐号])="19010150210046721" Or ([准贷记卡明细表FULL].[帐号])="19010150210043892" Or ([准贷记卡明细表FULL].[帐号])="19010150210043146" Or ([准贷记卡明细表FULL].[帐号])="19010150220047195" Or ([准贷记卡明细表FULL].[帐号])="19010150220055741")); |