0 Replies Latest reply: Aug 23, 2012 10:02 AM by Stefano Peroni RSS

    sql select

    Stefano Peroni

      Dear all,

      I'm facing the follwing problem:

       

      Table1                                                Table2                                                                                  Table3

      Order Nr   Ord.Date CampaignCode      CampaignCode  Order nr.  other infor concerning Campaign      Campaigncode      Customer     Start / End Date

      100         01-02-12   PROMO                      PROMO               100      FLAGS ....                                    PROMO               A            01-01-12  31-03-12

      101         15-04-12   PROMO                      PROMO               101      .....                                               PROMO               A            01-01-12  31-03-12

      101          15-04-12  PROMO                      PROMO                101     ...                                                 PROMO               B            01-01-12  30-04-12

       

       

      I need to get all the records where Order date is included into the Campaign start/end date, in  this case the first and last line.

       

      How can I solve it by an sql select ?

       

        Help please

       

       

      Thanks in advance