PERFIL MEMBRO
2204
UPDATE SIC2204 SET ACESSO = 'S' WHERE (IDMODULO = 1 OR IDMODULO = 13 OR IDMODULO = 14) AND IDUSUARIO = 1723
2205
UPDATE SIC2205 SET ACESSO = 'S' WHERE (IDPROGRAMA = 1 OR IDPROGRAMA = 101
OR IDPROGRAMA = 102
OR IDPROGRAMA = 179
OR IDPROGRAMA = 180
OR IDPROGRAMA = 183 OR IDPROGRAMA = 190) AND IDUSUARIO = 1723
select * from sic2252 where idusuario = 106
delete from sic2252 where idusuario = 858
insert into sic2252(idusuario,idvinc, idtipo, ordem, type_indicador
, Color_default, color_up, color_down,
color_default_celular, color_down_celular
, color_up_celular, DASHBOARD)
select sic2203.idusuario,sic2252.idvinc,
sic2252.idtipo,sic2252.ordem,sic2252.type_indicador
,sic2252.Color_default,sic2252.color_up,sic2252.color_down,
sic2252.color_default_celular,sic2252.color_down_celular
,sic2252.color_up_celular,sic2252.DASHBOARD
from sic2203,sic2252 where sic2252.IDUSUARIO = 1706 and sic2203.IDUSUARIO = 1723
onde o da sic2252 é o que vc quer copiar e o sic2203 onde quer colar