Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- begin transaction
- UPDATE peninsula_rh.pen_cadastro as CADAS
- left OUTER JOIN novosusuarios
- ON novosusuarios.id <> CADAS.id
- set
- CADAS.id = novosusuarios.id
- group by novosusuarios.id
- SELECT novosusuarios.*
- FROM pen_cadastro
- left OUTER JOIN novosusuarios
- ON novosusuarios.id <> pen_cadastro.id
- group by novosusuarios.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement