comparing data in the same field and table [message #328242] |
Thu, 19 June 2008 08:34  |
jenlove
Messages: 1 Registered: June 2008 Location: New York
|
Junior Member |
|
|
Good Morning Everyone,
I have the following information in a table:
Refno Def_Id Insp_date ver_date
40047 33344 4/20/2000 4/22/2000
40047 39909 6/4/2001 6/5/2001
40047 45677 6/12/2008 2/14/2008
145888 166332 6/8/2008 6/10/2008
I would like the query to look at all the ver_dates within a refno and if the earliest date is before a specified date (could be today's date), then I would like to not have any of those records returned for that refno.
In the above case, since Refno 40047 has 3 entries and the earliest ver_date for Refno 40047 is 4/22/2000, I don't want to return any of those records.
Thank you for any light you can shed on this as I have tried numerous methods with no solution in sight
|
|
|
|
|