Guest User

Untitled

a guest
Jun 18th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. SELECT nova.codigo AS codigonv
  2. ,nova.nome AS nomenv
  3. ,nova.celular AS celularnv
  4. ,atual.codigo AS codigoatual
  5. ,atual.nome AS nomeatual
  6. ,atual.celular AS celularatual
  7. FROM contatonovo AS nv
  8. FULL JOIN contato AS atual
  9. ON (nv.codigo = atual.codigo)
  10. WHERE atual.codigo IS NULL
  11. OR atual.nome IS NULL
  12. OR atual.celular IS NULL
  13.  
  14. SELECT Nova.codigo, Nova.nome, Nova.celular
  15. FROM contatoNovo nova
  16.  
  17. EXCEPT
  18.  
  19. SELECT atual.codigo, atual.nome, atual.celular
  20. FROM contato atual
  21.  
  22. SELECT atual.codigo, atual.nome, atual.celular
  23. FROM contato atual
  24.  
  25. EXCEPT
  26.  
  27. SELECT Nova.codigo, Nova.nome, Nova.celular
  28. FROM contatoNovo nova
Add Comment
Please, Sign In to add comment