It would seem to make sense to put common, essentially static,
reference tables into a separate database that could be accessible to
various projects, each project corresponding to a separate database.
Helen Borrie's text mentiones transactionality across multiple
databases, but I have been unable to find how you would refer to such
a lookup table from another database either as a foreign key or in a
WHERE clause. Can anyone tell me how to do it, or point me to a
reference resource? Thanks.