求助：６个表的数据处理

解释：每一对主子表之间是通过XH=ZBXH来关联，在单的条件是审核日期不为空及入库数小于采购数量，入库的类型(RKLX)为“采购入库”及审核日期(SHRQ)不为空，同时要考虑损益值的上限与下限，如采购数量是100，收货是95，由于损益值是+-5%,故算已收完货，没有在单数，以及还要考虑单位换算问题，因为采购单位与库存单位不一定相同，部分需要转换。 非常感谢！想得到的结果：                                                  WLBM         SL(在单数量)    KCDW(库存单位)  采购单号          JHQ(交货期)             SJS0010004      30                公斤      CGDH0908010008    2009-9-20 17:14         SJS0010005      60                公斤      CGDH0908020002    2009-9-25 17:14         ZPGA2230G08800960GDF    45        令        CGDH0908020006  2009-10-15 17:14  有以下６个表： 采购单主表(CG_CGD_M)XH      BDBH(采购单号)  SHRQ(审核日期)  …                                                              1       CGDH0908010001  2009-8-1 17:10                                                                  2       CGDH0908010002  2009-8-1 13:10                                                                  3       CGDH0908010004                                                                          4       CGDH0908010008  2009-8-1 17:14                                                                  5       CGDH0908020002  2009-8-2 14:14                                                                  6       CGDH0908020007  2009-8-2 14:14                                                                  7       CGDH0909020001  2009-9-2 14:14                                                                  8       CGDH0908020003  2009-9-2 16:14                                                                  9       CGDH0908020006  2009-9-2 15:14                                                                  采购单子表(CG_CGD_D)                                                                                    ZBXH  ZBXH_WLBM 　WLMC 　　GG 　　XH 　　　PP 　　CGSL 　CGDW  　　JHQ(交货期)     SX(损益值上限) XX   …1  FBG0080004      墨盒            G-99    惠普    10      件      2009-8-10 17:14                 1  FBG0080005      硒鼓            T45     惠普    20      件      2009-8-10 17:14                 2  SJS0010002      热熔胶1 20/H            XX      30      公斤    2009-8-7 17:14          3  SJS0010003      热熔胶2 21/H            XX      40      公斤    2009-8-8 17:14          4  SJS0010004      热熔胶3 22/H            XX      50      公斤    2009-9-20 17:14         5  SJS0010005      热熔胶4 23/H            XX      60      公斤    2009-9-25 17:14         6  SJS0010006      热熔胶5 24/H            XX      70      公斤    2009-8-11 17:14         7  SJS0010007      热熔胶6 25/H            XX      100     公斤    2009-10-12 17:14   5%      5%8  SJS0010008      热熔胶7 26/H            XX      100     公斤    2009-10-13 17:14   5%      5%9  ZPGA2230G08800960GDF  光铜纸  880*960   YY      10      吨      2009-10-15 17:14        4%      3%
入库主表(KC_CLRK_M)                                                                             XH      BDBH             RKLX           SHRQ    …                                               1       FLRK0908100003  采购入库        2009-8-10 17:14                                                 2       FLRK0908100004  采购入库        2009-8-10 17:14                                                 3       FLRK0908100005  采购入库        2009-8-10 17:14                                                 4       FLRK0908100006  采购入库        2009-8-10 17:14                                                 5       FLRK0908100007  采购入库        2009-8-11 17:14                                                 6       FLRK0908100008  采购入库        2009-9-12 17:14                                 7       FLRK0908100009  采购入库        2009-9-13 17:14                                 
入库子表(KC_CLRK_D)                                                             ZBXH    ZBXH_BDBH       ZBXH_WLBM       WLMC    GG      XH      PP      RKSL    KCDW1       CGDH0908010001  FBG0080004      墨盒            G-99    惠普    10      件1       CGDH0908010001  FBG0080005      硒鼓            T45     惠普    20      件2       CGDH0908010002  SJS0010002      热熔胶1 20/H            XX      30      公斤3       CGDH0908010008  SJS0010004      热熔胶3 22/H            XX      20      公斤4       CGDH0908020007  SJS0010006      热熔胶5 24/H            XX      70      公斤5       CGDH0909020001  SJS0010007      热熔胶6 25/H            XX      95      公斤6       CGDH0908020003  SJS0010008      热熔胶7 26/H            XX      105     公斤7       CGDH0908020006  ZPGA2230G08800960GDF    光铜纸  880*960 YY      30      令
物料基础主表(JCZL_WLBM_M)                                                               XH      WLBM            WLMC     GG      XH      PP     KCDW            1       FBG0080004      墨盒            G-99    惠普    件2       FBG0080005      硒鼓            T45     惠普    件3       SJS0010002      热熔胶1 20/H            XX      公斤4       ZPGA2230G08800960GDF    光铜纸  880*960  YY      令
物料基础子表(JCZL_WLBM_D)                                               ZBXH    ZBXH_DW HSBL                            1       NULL    NULL                            2       NULL    NULL                            3       NULL    NULL                            4       吨      7.5     备注：即1吨=换算比率7.5 * 库存单位令,如10吨=75令                        
                                                     

解决方案 »

  1.   

    根据你给的条件，无法进行处理，一共有6张表，3对，没这个主表和子表的通过xh=zbxh来关联，但是主表之间呢？关联条件是什么。
      

  2.   

    除了XH=ZBXH外，是通过WLBM来連接，还有就CG_CGD_M的BDBH与入库子表KC_CLRK_D的ZBXH_BDBH来連接。