>
> Is there a way to join data from two database in one query/view?

No.

It is possible to create a transaction that spans both databases to
give you a consistent snapshot of both, which supports 2 phase commits
etc, but you will have to merge the results together in the client end.

Adam