In article <008401c43133$8f1f41e0$0100a8c0@kevmain>, Kevin wrote:

> All this information is stored in a separate file to keep the updating
> process simple. We have to use some creative coding to join this data
> together. How great it would be to use a simple union and join SQL
> statements that reference different db's to replace all that code...=)

Use that file as an external table and then you just have one database

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly