Creating Joins Between External Database Servers

You can use the same notation in a join. When you specify the database name explicitly, the long table names can become cumbersome unless you use aliases to shorten them, as the following example shows:

SELECT O.order_num, C.fname, C.lname
   FROM masterdb@central:customer C, sales@boston:orders O
   WHERE C.customer_num = O.Customer_num