Joseph L. Casale wrote: > I have a table t1 that I am trying to create a view from where the > view will produce many rows for each row in t1. The resulting data > is a set of rows which assign a text string for each bit flag present in > a column in t1 from an enum I reference. > > How does one construct such a view?
Join that table with the table that contains the enum values: SELECT ... FROM t1 JOIN enums ON t1.flags & enums.bit != 0; Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users