Help on complex query
From: Peter B.L. Rasmussen (anonymous_at_discussions.microsoft.com)
Date: 04/26/04
- Next message: Mansoor Azam: "Unique constraint index"
- Previous message: Tibor Karaszi: "Re: Please answer my queries for fresh Installation"
- Next in thread: David Portas: "Re: Help on complex query"
- Reply: David Portas: "Re: Help on complex query"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Mansoor Azam: "Unique constraint index"
- Previous message: Tibor Karaszi: "Re: Please answer my queries for fresh Installation"
- Next in thread: David Portas: "Re: Help on complex query"
- Reply: David Portas: "Re: Help on complex query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|