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
