[Users] Subselect does not wor

[Nicolai Tufar]

Greetings!

Am I wrong or is it a real limitation of Ingres. Subselect does not work
when placed after FROM. Example:

CREATE TABLE X (Y INTEGER);
SELECT * FROM (SELECT * FROM X) AS YYY;
  E_US0845 Table 'select' does not exist or is not owned by you.

Every other database, even MySQL supports it. Is it true that Ingres does not
support it?

Kindest regards,
Nicolai Tufar