What is the SQL syntax for joining tables from multiple Databases in
Pervasive?

Thx.

Like Other database environments, use the "." notation:

SELECT T1.*, T2.*
FROM Table1 T1
INNER JOIN OtherDatabase.Table2 T2
ON (T1.ForeignKey = T2.PrimaryKey)

Use your own names, of course. Also, please note that it is the Named
Database (DBName) that must be referenced, NOT the DSN name. As such,
you cannot issue this across servers, either.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 08/28/2007 ***


datenisis wrote:



--