Hasan Haliciogl
New Member
Simple SQLQUERY below works MSSQL and ORACLE.
-------
Select CustNum,
(Select Sum(TotalPaid) From Invoice)
From Customer
-------
But when I call this simple query from ODBC connection on Progress DB, ODBC driver generate "SQL syntax error".
Why doesn't work. Is this an SQL92 capability problem?
-------
Select CustNum,
(Select Sum(TotalPaid) From Invoice)
From Customer
-------
But when I call this simple query from ODBC connection on Progress DB, ODBC driver generate "SQL syntax error".
Why doesn't work. Is this an SQL92 capability problem?