SQL Query question

I have an odd one for everyone and hopefully someone can help me.

I have a process that selects from table 1 using a left join to Table
2. Table 2 contains the records that have already been selected and
the query is design to only select new records out of table one. THe
process then adds the records to Table 2 so the next time only new
records from table 1 are selected. THis process has been working for 2
years without fail until one day last week where the results from the
query was all the records from table 2 + the new records and resulted
in sending duplicate records.

Can anyone help me understand under what circumstances a left join
would fail? when we looked the next morning all the records were in
table 2 twice, there was no evidence that anyone had deleted the rows
and then rolled back. The process has run as designed every night
since then and the only other odd event that night is that about 2
hours before the query was run the partition ran out of space breifly.

I am at a loss to explain this and any assistance would be helpful.


Thanks

.

Relevant Pages

  • Re: Updating Linked Table Data
    ... in the list of available objects in the Design View of my Query. ... Odd. ... John W. Vinson [MVP] ...
    (microsoft.public.access.queries)
  • Re: Confessions of a paranoid woodworker
    ... computer's acting flaky and just odd (and you don't have a virus or ... somewhat flaky and odd. ... As far as ventilation design, ... When I've cracked open this old tower in the ...
    (rec.woodworking)
  • Re: OT electrical _and_ electronic design software
    ...  It strikes me as odd that there is no software for folks ... Viewlogic will break up a design into a hierarchy with each module's ... The interconnect cabling could come from the master ...
    (rec.crafts.metalworking)
  • Odd and Even numbers
    ... I added a autonumber field to the table so now all the odd ... I intended to do a make table query selecting only the odd ... table with only business names, then do a make table query ...
    (microsoft.public.access.queries)
  • Re: The 14 y/o who stabbed another girl - over an internet row
    ... Odd that you fail to see that when the purp is black...the police rarely ... I bow to your superior cut n paste powers freda.....guess I'll just ...
    (uk.politics.misc)