Suppose I have the following two tables
foo:
10 | A | A
20 | B | B
30 | C | C
and
bar:
1 | A | X
2 | B | C
3 | A | A
4 | C | A
5 | B | B
I want to select all the rows in table bar where the second and third
column match an entry found in foo (that is to say, I want my result
to be 3 | A | A and 5 | B | B.
My attempt of:
select * from bar
where col2 in (select col2 from foo where bar.col2 = col2)
and col3 in (select col3 from foo where bar.col3 = col3)
Does not work, and I understand that is should not (it returns 2 | B |
C, 3 | A | A, 4 | C | A, 5 | B | B).
Could someone give me a hand?
--
Rich
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
