My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
recordarsql  
Updated Jan 15, 2011 by pablo...@gmail.com

insert into lista_cliente_mkt (id_lista,id_cliente, rut,nombre,ciclo)

select 1 as id_lista,id_cliente, rut,nombre,ciclo from campana_cliente_mkt where id_cliente not in (select id_cliente from lista_cliente_mkt)

Comment by project member pablo...@gmail.com, Jan 15, 2011

update lista_cliente_mkt set estado_registro = 4, numero_gestiones = numero_gestiones + 1

where lista_cliente_mkt.id_cliente in

(select id_cliente from a_frenar where a_frenar.id_cliente = lista_cliente_mkt.id_cliente)

Powered by Google Project Hosting