Looks like all roads are pointing to creating a Normalized table structure.
So if I were to add another table Person_Team table and not use the string as everyone is suggesting, then how would the SQL statement look to retrieve the data. On 5/22/14, Hick Gunter [via SQLite] <ml-node+s1065341n75770...@n5.nabble.com> wrote: > > > No. The internal table stores only unique keys. > > -----Ursprüngliche Nachricht----- > Von: Humblebee [mailto:fantasia.d...@gmail.com] > Gesendet: Donnerstag, 22. Mai 2014 11:39 > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] Simple Select from IN - from a newbie. > > Thank you everyone for your kind input and suggestions. That is quite a lot > to consider. I didn't realize it would be so difficult for a Select > statement to return a string. > > Out of curiosity, when I do: > > SELECT * > FROM Person WHERE id IN(2,2,3,3) > > It doesn't seem to give back 4 rows, only 2. Looks like the duplicates are > not being returned. Is there someway to get back all 4 rows. > > > > On 5/22/14, Keith Medcalf [via SQLite] > <ml-node+s1065341n75767...@n5.nabble.com> wrote: >> >> >> Andy Goth wrote: >> >>>And honestly, please don't give people with no knowledge of SQL theory >>>the power to set your SQL schema in stone. >> >> I am sure you mean Relational Theory, when using a database >> implementing Relational semantics, such as SQLite. >> >> There is no requirement that SQL (Structured Query Language) be >> implemented to query a Relational Database. There are many >> implementations which use SQL to query data from hierarchical, >> network, network extended, and a myriad of other underlying database >> storage mechanisms. SQL no more binds the relational model than using >> COBOL (a computer programming language) binds the implementation to a 4341 >> SysPlex running OS/VS1. >> >> SQLite implements an SQL interface using a relational access model >> against an ISAM datastore. Storing mutivalued (array) items is a >> violation of the Relational Model, not SQL and not ISAM. If you used, >> for example, ADABAS, then you could store arrays in a table field and >> perform SQL operations against them as if they were a BCNF normalized >> relational N:M join table. >> Some other not-so-relational relational databases support nonstandard >> means of achieving the same thing. >> >> >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> >> >> _______________________________________________ >> If you reply to this email, your message will be added to the >> discussion >> below: >> http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbi >> e-tp75751p75767.html >> >> To unsubscribe from Simple Select from IN - from a newbie., visit >> http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=uns >> ubscribe_by_code&node=75751&code=ZmFudGFzaWEuZG9zYUBnbWFpbC5jb218NzU3N >> TF8MTk4Njk4NTgwNw== > > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75769.html > Sent from the SQLite mailing list archive at Nabble.com. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ----------------------------------------------------------------------- > Gunter Hick > Software Engineer > > Scientific Games International GmbH > Klitschgasse 2 – 4, A - 1130 Vienna, > Austria > FN 157284 a, HG Wien > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This e-mail is confidential and may well also be legally privileged. If you > have received it in error, you are on notice as to its status and > accordingly please notify us immediately by reply e-mail and then > delete this message from your system. Please do not copy it or use it for > any purposes, or disclose its contents to any person as to do so could be a > breach of confidence. Thank you for your cooperation. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > If you reply to this email, your message will be added to the discussion > below: > http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75770.html > > To unsubscribe from Simple Select from IN - from a newbie., visit > http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=75751&code=ZmFudGFzaWEuZG9zYUBnbWFpbC5jb218NzU3NTF8MTk4Njk4NTgwNw== -- View this message in context: http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75771.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
