Kbase P84727: It is possible to define an SQL 89 view to join two tables located in two separate databases
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/17/2004 |
|
Status: Unverified
GOAL:
Is it possible to define an SQL view (SQL 89) to join two tables that are located in two separate databases?
FACT(s) (Environment):
Progress 8
FACT(s) (Environment):
Progress 9
FIX:
Yes. The following example creates a view in the otherDb database, which works fine with customer table in sports2000 database and order table located in otherDb database :
CREATE VIEW otherDb.mycust
AS SELECT sports2000.customer.NAME, sports2000.customer.custnum, otherDb.order.ordernum
FROM sports2000.customer, otherDb.order WHERE sports2000.customer.custnum = otherDb.order.custnum.
Note this document is about SQL 89 in 4GL, that has nothing to do with SQL-92.