On 5 March 2014 10:24, Igor Korot <ikoro...@gmail.com> wrote: > Hi, Simon, > . . . >> >> Possibly: >> select v1, v2 from ( select 1 as ordr, f1 as v1, f2 as v2 from t union >> all select 2, f3, f4 from t ) order by ordr, v1; >> > > With UNION I will have 2 DB hits, correct? > Meaning I execute the part on the left side of the UNION and then execute > the right side of the UNION > and then add the results together. Do I understand correctly?
I'm not sure. It is a single SQL statement > > Thank you. > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users