Re: Updating column to link one table to another

Mark Collette wrote:
> 
> Now, I've added the infrequentId columns to both, as an optimization, so 
> that I can quickly find the InfrequentTable entry for a given 
> FrequentTable entry.  I've done this because I want to speed up 
> SELECTs.  Any new INSERTs are working just fine.  But, all my legacy 
> entries, are not linked up yet.  I need to know how I can UPDATE the 
> FrequentTable rows, where their infrequentId is zero, to point at the 
> last InfrequentTable entry whose timestamp ts is before its own 
> timestamp ts.

How do you distinguish between InfrequentTable entries when their 
timestamp is the same?

--  Richard Huxton  Archonet Ltd