I have two tables say table1 and table2 with below details

```
create table test1(id number, name varchar2(20)); 
insert into test1 values(11,'micro'); 
insert into test1 values(22,'soft'); 

create table test2(id number, name varchar2(20)); 
insert into test2 values(77,'micro,soft'); 

```

1) if I use below query I am getting no rows selectd

```
select * from test1 t1 where t1.name in ( select ''''||replace(t2.name,',',''',''')||''''  from test2;

```

2) if I fire subquery alone output I am getting is : `'micro','soft'`

```
select ''''||replace(t2.name,',',''',''')||''''  from test2;

```

but if I fire query(1) I need the result 

```
id   name
------------
11 micro
22 soft

```

can some one please help me to get the same result with query (1).