If you look at the SQLite grammar in lang.html, you'll see
that parentheses are not allowed around a table-list. That's
why you're getting an error.
If you remove either of the first 2 left parens (and its
corresponding right paren), the query will work, but the
outer select and the first subselect serve no purpose. It's
hard to predict performance just by reading a query, but this
looks pretty inefficient. How about
select * from
INSCLAIMS t0
left join
(select * from INSCLAIMS_CONCAT
where INSCLAIMS_CONCAT_FIELD_ID = 'INSCLAIMS_POLICYNO') t1
on t1.INSCLAIMS_ID = t0.INSCLAIMS_ID;
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
