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 ?
Thanks in advance