Progress Support answered my question...
:)
Use this as an example and refer to the SQL92 Guide and Reference for valid SQL statements that you are allowed to use.
CREATE VIEW custOrd AS
SELECT cust.custnum,ord.ordernum
FROM pub.cust, pub.ord where cust.custnum = ord.ordernum;
Open Unix 8, Progress 9.1D, NT4
Accessing an existing Progress DB via "Merant 3.60 Progress SQL92" ODBC.
Table relationships are not defined, software access controlled relationships.
In building 'joined' SQL views we require table relationships to be defined.
Using SQL create table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.