Andrew:
Select
field_1
, field_2
...
, field_17
from new_query
where
field_1 not in (select field_1 from old_query)
AND (...the other 16 fields?)
the uniqueness may not be confined to just one field/column. I think
it's a unique row that's different OR (more likely) duplicate rows of
the sam
can you left outer joins in query-of-queries? I don't know if you can, but if
so, that would be a good palce to start.
otherwise, order the fields the same, paste the results into excel, and run
your eye over it. :-0
>>> [EMAIL PROTECTED] 20/04/2006 11:37 am >>>
hi all
I have 2 multi-tabled
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 allI have 2 multi-tabled queries that I need to compare.the origional is horribly written and returns 1242 results.
the "new improved" query returns