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