Luciano Rocha Posted September 4, 2013 Topic Count: 2 Topics Per Day: 0.00 Content Count: 4 Content Per Day: 0.00 Reputation: 0 Achievement Points: 40 Solved Content: 0 Days Won: 0 Status: Offline Age: 40 Report Posted September 4, 2013 Olá pessoal, Preciso detectar os lançamentos que existem na EDESCLAN (CODLANC) mas que não estão presentes ma FLAN (IDLAN). Preciso deixar as duas tabelas idênticas. Quote
Frederico Posted September 8, 2013 Topic Count: 11 Topics Per Day: 0.00 Content Count: 1,140 Content Per Day: 0.20 Reputation: 60 Achievement Points: 6,165 Solved Content: 0 Days Won: 33 Status: Offline Age: 43 Device: Windows Report Posted September 8, 2013 Luciano, Poderia tentar algo assim: SELECT CODLANC FROM EDESCLAN WHERE CODCOLIGADA = 1 AND CODLANC NOT IN (SELECT IDLAN FROM FLAN WHERE CODCOLIGADA = 1) Essa é uma forma existe outras também. []'s Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.