I'm looking for what the Progress SQL syntax for selecting without a table is.
For example, in Oracle you can do:
SELECT 1 FROM DUAL
or in T-SQL (SQL Server) you can do:
Both of these will return one row with one column with a value of 1. Of course, the constant 1 can also be replaced by an expression, and the rows from this select can be joined or unioned with other queries.
Of course, these are just simple examples. I have something more complex in mind, hence why I need to be able to do this from a SQL query not get it some other way.