[sqlite] Query problem

[Simon Berthiaume]

Yep, it's me again (no I haven't solved my other problem yet). This time
I was wondering why the SQL engine of SQLite works fine with the
following query:
SELECT *
FROM
   (
      SELECT * from INSCLAIMS
   ) AS T0
   LEFT JOIN 
   ( 
      SELECT * FROM INSCLAIMS_CONCAT WHERE
      ( 
         INSCLAIMS_CONCAT_FIELD_ID = 'INSCLAIMS_POLICYNO' 
      )
   ) AS T1
   ON T1.INSCLAIMS_ID = T0.INSCLAIMS_ID
;

But returns an error (SQL error: near "(": syntax error) with the
following query:
SELECT *
FROM
   (
      (
         SELECT * from INSCLAIMS
      ) AS T0
      LEFT JOIN 
      ( 
         SELECT * FROM INSCLAIMS_CONCAT WHERE
         ( 
            INSCLAIMS_CONCAT_FIELD_ID = 'INSCLAIMS_POLICYNO' 
         )
      ) AS T1
      ON T1.INSCLAIMS_ID = T0.INSCLAIMS_ID
   ) AS foo
;

So why do I have this behavior, does SQLite only support a maximum
degree of "inner-ness" in queries?


Simon Berthiaume