Re: Date range problem

waseem altaf <[email protected]> Tue, 18 Mar 2003 06:28:28 -0800 (PST)

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-917065-2003.03.18-14.27.26--gcdod-oracle#[email protected]>

Hi 

I have a table named "Vehicle_Booking" this table has two fields
"Booking_From_Date" and "Booking_To_Date" .

Scenario:
       If a vehicle is booked from 5-JAN-2003 To 10-JAN-2003 by an employee A . another employee B comes and want to book it 
from 8-JAN-2003 to 12-JAN-2003. 

I want to check whether the vehicle is already booked by some employee or not before assigning vehicle to employee B.
How can i do this.

Thanx in advance.



_____________________________________________________________
100% private, FREE email for life!
Visit http://inbox.com.pk

_____________________________________________________________
Select your own custom email address for FREE! Get [email protected] w/No Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].