From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch Sent: Saturday, April 8, 2017 7:15 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Create view from a single table as one to many
> Join that table with the table that contains the enum values: > > SELECT ... FROM t1 JOIN enums ON t1.flags & enums.bit != 0; > > > Regards, > Clemens Heh, I can't believe I missed that:) I'll add a table with the enum values. Thanks Clemens, jlc _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users