IN MISTERY

 Hi all

 I have the next query with the in clause, and it doesn´t works, any idea?.

 I f i execute the query,

    select'''||replace(tipos, ', ' , ''', ''')||'''' from lista_pautas where id_pauta='6'
i get the result:

   'palabras', 'negritas', 'sin cargo breves'

With the query,

    select lista_tipo_publi from lista_tipo_publi where lista_tipo_publi in ('palabras', 'negritas', 'sin cargo breves') i get the result:

   4
   9
   50

But if I try with the quey:

    select lista_tipo_publi from lista_tipo_publi where lista_tipo_publi in
(select'''||replace(tipos, ', ' , ''', ''')||'''' from lista_pautas where id_pauta='6')

  I get 0 rows as result. Any idea about that. Is the IN clause working wrong.

  Is there another way to do the same query without the IN clause.

Thanks for your responses, Received on Mon May 15 2000 - 09:09:21 CDT