Thank you for your replies. I'm sorry for not being super clear about the problem:
Note: The parId belongs to another table not shown here. TeamTable +---------------------------------+ | id | parId | personIds | +---------------------------------+ | 1 | 4 | 1,5,2,3,4 | | 2 | 5 | 2,6,3,5,1 | +----------------------------------| PersonTable +------------------+ | id | name | +------------------+ | 4 | 4 | | 5 | 5 | +---------+-------+ @Simon, thank you for showing me a better way to setup the tables, your way makes much more sense, only problem is that in this situation, the tables have already been defined and made by someone else so I cannot change it. I'm a bit stuck with the way it is. @ Gunter, the picture above is a better representation of the tables. After searching on the net for an answer, I think what I want is a way to get a subSelect statement to return something that the Select from IN (string) can work. At least this is what I'm thinking from my very very limited understanding of SQL and with the way that I'm trying to do this. On 5/21/14, Hick Gunter [via SQLite] <ml-node+s1065341n7575...@n5.nabble.com> wrote: > > > You show a field parId in your TeamTable, but select it from the > PersonTable. Maybe you mean > > SELECT * FROM PersonTable WHERE id IN (SELECT personIDs FROM TeamTable WHERE > parId = 4); > > -----Ursprüngliche Nachricht----- > Von: fantasia dosa [mailto:fantasia.d...@gmail.com] > Gesendet: Mittwoch, 21. Mai 2014 15:00 > An: sqlite-users@sqlite.org > Betreff: [sqlite] Simple Select from IN - from a newbie. > > Hi all wonderful people on this list. > > I'm a newbilie so my questions might seem very well-- kinda dumb so please > forgive me. > > I'm trying to do the following in Sqlite. > > TeamTable - > parId: 4 > personIDs : 1,5,9,6 > > PersonTable - > id: > name: > > SELECT * FROM PersonTable WHERE id IN (SELECT personIDs FROM PersonTable > WHERE parId = 4); > > The result from the above query is empty whereas when I do: > SELECT * FROM PersonTable WHERE id IN(1,5,9,6) > > Then I get the result that I need. > > Any help is greatly appreciated. > > Cheers. > _______________________________________________ > 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-tp75751p75753.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-tp75751p75754.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
