On Wed, October 18, 2006 13:37, spacemarc said:
> 2006/10/18, Peter Brawley <peter.brawley@stripped>:
>> You can join on any row(s) you like. What are you trying to acccomplish?
> I simply want to select the records from my three tables that are
> comprised in time interval.
> Now, the first table comprises the records until to 2004 year; the
> second table unitl 2005 and the third table until 2006.
> If a user select a date (example) between 2005 and 2006 I want to
> select the data from two tables....
Then it is really a UNION. I hope you have the date field as an index
otherwise you are looking at a table scan which is always slow.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27