Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Prashant kulkarni
  Where is Prashant kulkarni?
 Mumbai
 India
 Prashant kulkarni
 Tags
Subject: Very Very Urgent
Thread ID: 311159 Message ID: 311159 # Views: 77 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Wednesday, June 29, 2011 10:33:21 AM         
   


Dear Experts

My Data is As Follows

Table1
---------------
Party_No Eff_DATE Cash Discount
-------- ----------- --------------
BS056 01/04/2009 4
BS056 11/05/2009 4
BS056 21/07/2010 3



Table2

Party_No Invoice No Invoice date Cash Discount
-------- ------------ ----------------- ----------------------
BS056 INV0001 05/04/2009
BS056 INV0002 01/09/2010


Now what i require is Invoice date of Table2 to be searched in between the eff date of Table 1 and cash discount should be updated in table 2


Expected Result

Party_No Invoice No Invoice date Cash Discount
-------- ------------ ----------------- ----------------------
BS056 INV0001 05/04/2009 4
BS056 INV0002 01/09/2010 3


Thanks in advance

ENTIRE THREAD

Very Very Urgent Posted by Prashant kulkarni @ 6/29/2011 10:33:21 AM
RE: Very Very Urgent Posted by Suresh Ramtekkar @ 6/29/2011 11:11:17 AM
RE: Very Very Urgent Posted by Prashant kulkarni @ 6/29/2011 11:47:56 AM
RE: Very Very Urgent Posted by Suresh Ramtekkar @ 6/29/2011 1:13:39 PM
RE: Very Very Urgent Posted by Cetin Basoz @ 6/29/2011 12:49:24 PM
RE: Very Very Urgent Posted by Prashant kulkarni @ 6/29/2011 1:14:49 PM