[sqlite] Simple Select from IN - from a newbie.

[fantasia dosa]

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