On Monday, 15 April, 2019 13:31, Mohit Mathur <m.mathur1...@gmail.com> 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 tables....columns that i am >selecting are exactly same in number and datatypes. >Please let me know why it is throwing error. Could be the phase of the moon or random gamma particles emitted by the Sun hitting your RAM chips just so. Or you could be doing something wrong. Any guess is as good as any other since you have not deemed to show the query and a schema sufficient to demonstrate your issue. As Mr Spock would say "There are insufficient referents for a meaningful discussion". >How intersect works in sqllite, i am well aware of oracle intersect....in >sqllite is it differnt? According to the SQL Standard, INTERSECT returns rows that appear in the right-hand SELECT if and only if they also are present in the left-hand SELECT. Does Oracle do something non-standard? --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
