I have 2 table like below and I need the client\_ID from client table and his Roles from roles table, but the condition to get the data the tables is, client whose is having more than one contribution\_type.

Please find the below sample table and output.

Client table

```
Client_ID   cname   Contribution_type
-------------------------------------   
   1        A       Regular
   2        B       public 
   3        C       regular
   4        D       private
   1        A       public 
   4        D       similar

```

Role table

```
Client_ID   Rname
------------------    
   1        owner
   2        owner
   3        trustee
   4        benificier
   1        trustee
   2        benificier
   3        owner
   4        owner

```

Output 

```
Client_ID   Rname
-------------------    
    1       owner
    1       trustee
    4       beneficiary
    4       owner

```

I've written the below query but getting the below error

```
select 
    c.cid, r.rname 
from 
    Client_table c 
join 
    role_table r on c.cid = r.CID
where 
    c.cid in (select cl.CID, count(Contribution_type) 
              from Client_table c 
              group by cl.CID 
              having count(Contribution_type) > 1);

```

Error message:

> 
> ORA-00913: too many values  
> 
>  00913. 00000 - "too many values"  
> 
>  \*Cause:  
> 
>  \*Action:  
> 
>  Error at Line: 21 Column: 9 
> 
> 
> 

Thanks in advance.