[Info-Ingres] Few questions concerning Ingres 2006

[Marek.Patrzek at gmail.com]

Welcome,

As topic says, I got few questions that rely concern me. First of all,
I have to say, that I am totally newbie at this issue and I haven't
been using earlier versions of Ingres neither.

1st question - is it rely true, that I can use only 32 (or 31, I can't
recall that number correctly) joins in my query ?
2nd question - is it also true, that Ingres 2006 does NOT support
subqueries ? Or do I have to switch some parameters on ? Assuming I
have TABLE_A that consists only from one column - A (integer) I am
unable to do something like this:
SELECT
    *
FROM
    (
        SELECT
            A
        FROM
            TABLE_A
    ) tmp
'cos all I got is an error: "Unknown column / table SELECT".

Can I blame it on my JDBC ?

Thanks in advance :)