Kbase P17208: How to create a view on two or more tables?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/11/2008 |
|
Status: Verified
GOAL:
How to create a view on two or more tables?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Example code:
CREATE VIEW custOrd AS
SELECT cust.custnum,ord.ordernum
FROM pub.cust, pub.ord where cust.custnum = ord.custnum;
commit work;