My problem at this time is following: I have a table of position bookings, having information of a position code, beginning time of the booking and end time:
Pos | Begings | Ends ------------------------------------------------ APP | 2003-09-30 11:00:00 | 2003-09-30 12:15:00 APP | 2003-09-30 12:15:00 | 2003-09-30 13:00:00 DEP | 2003-09-30 10:30:00 | 2003-09-30 13:30:00 ...
Now I should make a query that, in some way, gives me an information of the positions that are booked without any pause for specified time. For example, 2003-09-30 11:00 - 2003-09-30 13:00 should return APP and DEP. Anyway, if I queried for period of 2003-09-30 10:30 - 2003-09-30 12:20, I should receive only DEP.
Any ideas how to build such a query?
Thanks for information, Ville M.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]