use results of query in another query

[Anonymous]

i should insert a result of query in another query .

my problem is the first query has many results and i should try the results in condition clause where (like)

example: 

the first query results are for example (1,2,3)

the second query is like that 

select code from codes where code like'%1%' and code like'%2% and code like'%3%'

i should have a dynamic query and i don't know which component i will use 

[Anonymous · Accepted solution]

thanks for the response 

i have executing the job but there is an error the query is not perfect !

it's like that:

select code_grille_talend from code where code_grille_talend like'%2%'and
select code_grille_talend from code where code_grille_talend like'%1%'and

it can't execute in the TSqliteinput error

that's why it's should be like: 

select code_grille_talend from code where code_grille_talend like'%2% and code_grille_talend like'%1%' 

Idea Please !!