Advertisement
Guest User

Untitled

a guest
Jul 25th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. begin transaction
  2. UPDATE peninsula_rh.pen_cadastro as CADAS
  3. left OUTER JOIN novosusuarios
  4. ON novosusuarios.id <> CADAS.id
  5. set
  6. CADAS.id = novosusuarios.id
  7. group by novosusuarios.id
  8.  
  9. SELECT novosusuarios.*
  10. FROM pen_cadastro
  11. left OUTER JOIN novosusuarios
  12. ON novosusuarios.id <> pen_cadastro.id
  13. group by novosusuarios.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement