The SQL statement SELECT (select_statement) is supported in MaxDB with restricted syntax (SELECT statement).
· MaxDB does not support the specification of START WITH <condition> or CONNECT BY <condition>.
· MaxDB sometimes rejects outer joins with more than two tables in the FROM clause valid in Oracle.
· If the results in a table that are obtained from a SELECT statement are to be updateable, the syntax element FOR UPDATE must be entered.