On 2014/03/05 12:24, Igor Korot wrote:
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? Thank you.
Yes. Obviously you need to have the same number of field results for the part before the UNION than the part after the UNION to be able to be one query result list at the end without nulls and such.
Also, when you don't want duplicates, just use "UNION", if you want all values to be listed, even if they are duplicates, use "UNION ALL"
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
