SQL question

Feb 10 2014 3:03 AM

Hi,
I want to search some values on"table_a"'s, "column1" column (for example 2,3,4) in "table_b"'s, column2 column and count this. How may I do this?

table_a
-----------------
column1
1
2
3
5
6
7
8
-----------------

table_b
-----------------
column2
2
4
5
6
7
8
9
-----------------