Create a VIEW that is a UNION of both tables and select on that view.

If you want to go for separate database that will no longer work and -
except for huge databases - I would keep the tables simply in one database.

Mark

cornievs wrote:

> I have two tables in a database that are identical. One for my current records and one for my historical records. I would like to run a query that extract records from both tables that meets a certain criteria and return it as a single result. (Sorting is preferred but not required.)
>
> In future I would to have the historical records in a separate database.
>
> Is there any version of Firebird current or future that can do it?
>
> I am using currently using Delphi 2006 and Firebird 2.05 with dbexpuibfire15.dll from UIB, but are in process of upgrading to 2009 and 2.1x
>
> Regards
>
>
>
> Cornie

--
Mark Rotteveel