On Thu, Jul 11, 2002 at 10:34:01 +0900,
"Huang@tanpopo-tane.com" <huang@tanpopo-tane.com> wrote:
> Can I use Inner join two tables between two databases?
You cannot do that.
> if possible, how to write this SQL? If not, any other way to accomplish it?
> thank you!
An application can talk to both databases so it could do the join or it
could copy the data from one database to a temporary table in the other
and do the join there.
You coulkd also consider doing a redesign and combining the two databases.