That looks and executes right... but I can't understand why the result is not only the number 4.
After the EXCEPT, only the number 4 remains. So where does that 5 come from in the INTERSECT part?
I'm testing it in SSMS but I don't get it. :unsure:
Best regards,
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA