>Probably, I misunderstand you. If it's databases from different servers,
>then I don't know whether it's possible at all. I would imagine that you
>could create the same database on both servers and make backup/replication
>link to provide that both databases will be identical. This is feasible, but
>I'm not SQL Administrator and cannot advise on this issue.
FWIW Sybase SQL Anywhere does not support joins across databases, even if they're running on the same server it doesn't matter, as far as the server cares they're completely separate database. Any joining would have to be done on the FoxPro side (via remote views) but performance would take a serious nosedive and it wouldn't be a good idea for any heavy duty joins.
-- Dave
--
David Mann
Software Developer
"I don't believe in 'isms', I just believe in me" -- Ferris Bueller