[Table A]        품목기초자료                                           [Table B 매출자료]

item_no      start_day         end_day                                day                    item_no             su

   1             2014--05-01        2014-05-30                      2014-05-20              1                 30                  합산에포함

  2             2014-05-20        2014-06-20                        2014-05-27               1                20                 합산에포함

                                                                                            2014-06-01               1                3                   합산에제외

                                                                                            2014-06-01              2              5                     합산에포함

조회하는 품목마다   table  a  같이   조회하는  일자를  정하구  품목별 합산구하기

  이런 결과값을 얻을려구 하느까요  

          1        50

          2         5