Re: [sqlite] Create view from a single table as one to many

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

Re: [sqlite] Create view from a single table as one to many

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

[sqlite] Create view from a single table as one to many

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? Thanks, jlc