Hi Barry
Select *
from new_query
where id not in (select id from old_query)
HTH
Antony
On 4/20/06, Barry Beattie <[EMAIL PROTECTED]> wrote:
hi all
I have 2 multi-tabled queries that I need to compare.
the origional is horribly written and returns 1242 results.
the "new improved" query returns 1245 results.
I want to see what the 3 "different" results are.
any suggestions? SQLServer2000
thanx
barry.b
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
- [cfaussie] comparing two queries - which records are d... Barry Beattie
- [cfaussie] Re: comparing two queries - which reco... Antony Sideropoulos
