Config: ODBC, Progress 9.1C on Windows
Issue: We're trying to use a Select statement to return a single summed value within the Column List of the main Select statement, but we keep receiving syntax errors. Can we do that using ODBC connecting to Progress 9.1C? We use subselects in the from clause ok.
Ex: Select table1.col1, table1.col2, (select sum(table.field) from table) as 'Total'
from table1 ...
TIA.
Russ
Issue: We're trying to use a Select statement to return a single summed value within the Column List of the main Select statement, but we keep receiving syntax errors. Can we do that using ODBC connecting to Progress 9.1C? We use subselects in the from clause ok.
Ex: Select table1.col1, table1.col2, (select sum(table.field) from table) as 'Total'
from table1 ...
TIA.
Russ