> > 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....
In addition to the other answers --
This sounds like a really bad database design, unless you have very specific
reasons for doing so.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!