On 5 Nov 2017, at 11:04am, Richard Hipp <d...@sqlite.org> wrote:
> SQLite does do a merge in some cases, though not for what you would > traditionally call a join. For example, SQLite will do a merge to > combine the two halves of this query: > > SELECT a,b,c FROM tab1 UNION SELECT x,y,z FROM tab2 ORDER BY 1,2,3; In case it’s not clear from the above, SQL processes the UNION before the ORDER BY clause. If "merge join" didn’t already have a definition, we could use the term for that. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users