well, I am working with mysql for less than 2 months so I may not give you right answer but I guess we cannot solve this problem without programming. The point is how to combine the times to have a one POS with continuous time. this query is an example to combine to records:
SELECT table1.pos, table1.Begings, table2.Ends FROM mytable as table1, mytable as table2 WHERE table1.pos = table2.pos AND table1.Ends = table2.Begings ORDER BY table1.pos, table1.Begings, table2.Begings but this is not working if there are 3 records (or more) which should be combined together. so if you don't have this case, you can work more on this query to have the other records and do the search on the final query. ----- Original Message ----- From: "Ville Mattila" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 10:56 AM Subject: Querying for continuous bookings > Hi there, > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
