On 20 Nov 2019, at 4:49pm, Andy Bennett <andy...@ashurst.eu.org> wrote:
> INNER JOIN "entrys"
> ON
> 1 = "entrys"."log-id" AND
> "specific-entrys"."key" = "entrys"."key" AND
> "user" = "entrys"."region" AND
> "specific-entrys"."entry-number" = "entrys"."entry-number"
> AND "entrys"."key" > "G"
I can't solve your problem, but the PRIMARY KEY for "entrys" is
("log-id", "entry-number")
. You shouldn't need to match so many different fields when just two of them,
which you already have values for, narrow your search down to a single row.
Though I may be missing something.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
