Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT nova.codigo AS codigonv
- ,nova.nome AS nomenv
- ,nova.celular AS celularnv
- ,atual.codigo AS codigoatual
- ,atual.nome AS nomeatual
- ,atual.celular AS celularatual
- FROM contatonovo AS nv
- FULL JOIN contato AS atual
- ON (nv.codigo = atual.codigo)
- WHERE atual.codigo IS NULL
- OR atual.nome IS NULL
- OR atual.celular IS NULL
- SELECT Nova.codigo, Nova.nome, Nova.celular
- FROM contatoNovo nova
- EXCEPT
- SELECT atual.codigo, atual.nome, atual.celular
- FROM contato atual
- SELECT atual.codigo, atual.nome, atual.celular
- FROM contato atual
- EXCEPT
- SELECT Nova.codigo, Nova.nome, Nova.celular
- FROM contatoNovo nova
Add Comment
Please, Sign In to add comment