Greetings!
I have these tables A and B:
A
id,projid,a,b
1,1,'a','h'
2,2,'b','i'
3,3,'c','j'
4,4,'d','k'
5,5,'e','l'
...
...
B
id,projid,ptask
101,1,'a'
102,2,'b'
103,3,'a'
104,4,'b'
105,5,'a'
...
...
When I do this SELECT,
SELECT * FROM A WHERE projid = (SELECT projid FROM B WHERE ptask = 'a');
This only returns one record (record 1) where it should return all the
records with ptask = 'a'. Will someone point me to the right syntax to get
this correct? Thanks for the help.
josé
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
