Re: [sqlite] Query problem

[D. Richard Hipp]

Simon Berthiaume wrote:
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
;

On what RDBMSes does the above query actually work?

--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]