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?

rather pointless... -Ursprüngliche Nachricht- Von: Jean-Christophe Deschamps [mailto:j...@antichoc.net] Gesendet: Montag, 27. Jänner 2014 18:57 An: sqlite-users@sqlite.org Betreff: [sqlite] How should I use parenthesis? Dear list, I'm trying to find the correct syntaxt for this, but I hit

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

[sqlite] How should I use parenthesis?

Dear list, 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 (subselectB) ) union all ( -- <-- error select *