Views in 5.01

[ChronoFish]

Hi there,

We have just loaded 5.01 so that we can take advantage of views. One
question I have before I start experimenting is this: Can you "view"
across databases? And if the answer is yes, can you "view" across
servers?

Given two tables "company" and "people", each living in a different
database (and potentially on different servers) can you give an
example (the SQL) of how to link them in a view?

assume the following:

company
-------
c_id
c_name
people
------
p_id
p_name
c_id

Thanks!
CF

[ChronoFish]

"ChronoFish" <de**@chronofish.com> wrote in message
news:95**************************@posting.google.c om...

Hi there,

We have just loaded 5.01 so that we can take advantage of
views. One
question I have before I start experimenting is this: Can
you "view"
across databases? And if the answer is yes, can you
"view" across
servers?

Given two tables "company" and "people", each living in a
different
database (and potentially on different servers) can you
give an
example (the SQL) of how to link them in a view?

The short answer to my question is "Yes" and "Don't think
so".

Yes you can span databases with views. We don't think there
is a (direct) way to do it across servers. Our solution to
the second problem will be to replicate the database, and
then create a view from the replicated tables.

-CF