Re: [sqlite] Intersect and Minus

2019-04-15 Thread Keith Medcalf
On Monday, 15 April, 2019 13:31, Mohit Mathur wrote: >I am working on one sqllite query, in which i am doing left outer >join between two tables and than using intersect and again doing >left outer join between two other tablescolumns that i am >selecting are exactly same in number and

Re: [sqlite] Intersect and Minus

2019-04-15 Thread Simon Slavin
On 15 Apr 2019, at 8:31pm, Mohit Mathur wrote: > Please let me know why it is throwing error. What error ? Do you have an error number or text ? If you perform the same SELECT in the SQLite command line tool do you get the same error ? ___

[sqlite] Intersect and Minus

2019-04-15 Thread Mohit Mathur
Hi tech gurus, I am working on one sqllite query, in which i am doing left outer join between two tables and than using intersect and again doing left outer join between two other tablescolumns that i am selecting are exactly same in number and datatypes.Please let me know why it is throwing