Simple sql

[Rex Rock]

Whats wrong with this sql.

Select col1, col2 from Table1 where col3 in ( select col2 from Table2 where col1 = 'xyz' )
Table 1
col1   col2   col3
kevin johson  100
Kasi  johnson 101

Table 2
col1 col2
xyz  100
xyz  101

All the columns are string type
I am expecting result kevin johnson and Kasi johnson, but it returns nothing.

[Beksy Kurian]

There is no problem with the sql. Make sure that your data(especially 'xyz') is stored in the same way(small letters) as in the where clause. I got the results using your sql statement.
Beksy