SQL Challenge

[Ian Skinner]

I've got a challenge for any and all SQL guru's.  I need to return a record set consisting of all records with a date in the future of today as well as one and only one record previous to the current date, if one exists.

Would this best be done with a union of two selects, or is there a trick that would allow this to be done in one select?

If it matters, this is against an Oracle 8 database and the date field is stored as an integer in the format of yyyymmdd.  

Thanks

--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
     - Cynthia Dunning

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---