Re: [sqlite] How should I use parenthesis?

On 1/27/2014, 9:57 AM, Jean-Christophe Deschamps wrote: I'm trying to find the correct syntaxt for this, but I hit a syntax error each time: either SQLite shokes on outer parenthesis or on union all. Try something like this, which is a minimal change from yours: (select * from (select * from

Re: [sqlite] How should I use parenthesis?

Perhaps you want: select * from ( select * from A where x in (subselectA) left outer join ( select * from B where y in (subselectB) ) as a on -- something ) as A1 UNION ALL select * from ( select * from B where y in (subselectC) left

Re: [sqlite] How should I use parenthesis?

Select A.*,B.* from A left outer join B on x in (subselectA) and y in (subselectB) Union all Select A.*,B.* from B left outer join A on x in (subselectD) and y in (subselectC) It seems strange that there is no condition limiting which rows from A and B match, which makes the LEFT OUTER JOIN

Re: [sqlite] How should I use parenthesis?

On Mon, 27 Jan 2014 18:57:26 +0100 Jean-Christophe Deschamps wrote: > ( > select * from A where x in (subselectA) > left outer join > select * from B where y in (subselectB) > ) > > union all > > ( -- <-- error > select * from B where y in (subselectC) > left outer join >

Re: [sqlite] How should I use parenthesis?

On 1/27/2014 12:57 PM, Jean-Christophe Deschamps wrote: I'm trying to find the correct syntaxt for this, but I hit a syntax error each time: either SQLite shokes on outer parenthesis or on union all. ( select * from A where x in (subselectA) left outer join select * from B where y in