Hi,
I need to match 2 tables and return the quote price with the begin date & end date, which the
1st table consists of all orders records & the 2nd table consists of quote/price contract (based on the effectiveness). i need to match based on the part#(table1&table2), then compare the order date (from table1) with the quote begin & end date (from table2) and return the quote price(from table2).
table1
Part# Order# OrderDate(dd/mm/yyyy)
xyz 101 02/01/2007
abc 102 15/04/2007
edf 103 06/07/2007
xyz 104 01/12/2007
edf 105 01/12/2007
table2
Part# BeginDate EndDate Price
abc 01/01/2007 15/02/2007 1.30
abc 16/02/2007 31/01/2008 2.30
edf 01/01/1997 31/12/2099 2.00
xyz 15/01/2004 31/12/2010 5.66
edf 31/03/2007 31/12/2099 4.33
Appreciate for your feedback.