Help on complex query

From: Peter B.L. Rasmussen (anonymous_at_discussions.microsoft.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 03:21:04 -0700

I have a table of items, with multiple records for each item, representing different prices for different periods, and a table which defines supplier rebates for different periods (may be different than item periods)

For example:

ITEMS: itemno, supplier_id, price, valid_from, valid_to:

1, 1, 1000, '01-01-2001'. '12-31-2001'

1, 1, 1100, '01-01-2002'. '12-31-2002'

1, 1, 1200, '01-01-2003'. '12-31-2003'

SUPPLIER_REBATES:

supplier_id, rebate, rebate_valid_to:

1, 10, '10-31-2002' (10% until 10-31-2002)

1, 12, '12-31-2010' (12% until 12-31-2010)

I need a query to list all items, with the corresponding rebate, according to valid_from date, e.g.:

RESULT: itemno, price, valid_from, valid_to, rebate

1, 1000, '01-01-2001'. '12-31-2001', 10

1, 1100, '01-01-2002'. '12-31-2002', 10

1, 1200, '01-01-2003'. '12-31-2003', 12

How do I do that?

Thanks in advance for your help

Relevant Pages

  • Re: Gloating ethics
    ... liquidating a lot of other software at really low prices. ... The real kicker was that it had a $200 rebate, ... I know that since they were cancelling orders that they ... honor a stupid price that was a mistake. ...
    (rec.woodworking)
  • 8/05: Good Time to Buy A Low-end Laptop
    ... If you're willing to file those rebate papers, ... Good prices on low-end notebooks abound this month, ... notebooks this year but currently four major retailers as well as PC ...
    (misc.consumers)
  • Re: Purchasing Security Software after the Fact
    ... pricegrabber.com is the best place to look for prices. ... cheat you as Franklin did with me, claiming they sent a $50 rebate check I ... Many will recommend "free" AV software. ... just as free i.e. worthless in your mind) is not money well spent. ...
    (alt.sys.pc-clone.dell)
  • Re: Staples Christmas commercial
    ... Prices are competitive, and their rebate program is something the whole industry should copy. ... they raise the total seeling price in any case, because of the extra staff ... marginally more profit than his competitors. ...
    (rec.photo.digital)
  • Re: Places to buy cellphones
    ... The Low prices are based on a rebate offer. ... Purchase the Motorola E815 with Verizon Wireless calling ... plan from Wirefly. ...
    (alt.cellular.verizon)