> We have a table which contains the following sample of information
> As you can see, the dates listed are not constant e.g missing 2010-03-29
> a example. For our query like SELECT check_in_date FROM bookings how
> I know to automatically insert a missing date like 2010-03-29 between the
> date range I search ?
So, you want to "select" something that isn't available from the database?
Makes you wonder why you need to go to the database for this at all...
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum: