Actualy none, there was an error in the statement I copied. But the
following works on Access (ADO) and Oracle as well, but not on SQLite.
Since I don't have access to any other RDBMS, I couldn't test others.
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
)
;
Simon Berthiaume
On Mon, 2004-01-19 at 12:52, D. Richard Hipp wrote:
> 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?
>
