Hi Chris,
You can use a table function to access a table in another database (the
other database could be Derby, MySQL, Postgres, etc.). For more
information on table functions, please see the Developer's Guide (
http://db.apache.org/derby/docs/10.5/devguide/devguide-single.html#cdevspecialtabfuncs
) and the white paper here:
http://developers.sun.com/javadb/reference/whitepapers/index.jsp
Hope this helps,
-Rick
cmoody12 wrote:
I would like to know if, in one Derby database, I can create a synonym to a
table that is in another Derby database. If so, please tell me what that
syntax is. Thanks in advance for any information you can provide!