SQL NEWBEE QUESTION

Have two Tables linked by a field. First Table is the active table with
current data - The second table is like a History table of the First one.
When data is changed on the First Table, a History record is generated for
it showing the data before the change. So over time, the History file
builds up a lot of records, and that's ok, not the problem I am having other
than the History table can be large.
What I need to have happen is to have a quick way (SQL) to go thru the
History table, and replace some data into a History Table Field based upon
whether that History records's counter part in the Main Table has been
deleted (not there anymore). We still want to keep History Records of those
deleted in the Main. Am I making any sense?
Anyway, the SQL code for it would be something like:

UPDATE HISTORY.DBF SET HDUPNUM = "1" INNER JOIN MAIN ------- and here I
get lost....

Please some specific systax in your response, and if you need better
clarification and/or more information, let me know.

Thanks!!

RW



.

Relevant Pages

  • Re: Right Wing Spin
    ... Does Lars? ... So the dimwit never left. ... Mr. M's history over the years of accusing various posters of really being ... now that their heewo's teats aren't here to suck on anymore. ...
    (alt.guitar.amps)
  • Re: Y&R SPOILER
    ... in their work or have a work *ethic* anymore? ... that NOBODY would continue to get a fat paycheck ... insult to all of us who wasted our time watching so faithfully ... Which is why a "retcon" that restores history works for me. ...
    (rec.arts.tv.soaps.cbs)
  • IE6 "Internet Options..." menu item problem
    ... When I go to Tools | Internet Options... ... I do not see the tab that allows ... you to set you homepage, clear history, etc anymore. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Allentown review
    ... i like JBC for history, but isn't fan friendly anymore ... DRUMAJOR wrote: ...
    (rec.arts.marching.drumcorps)
  • Big Bang Bar history request
    ... Love to read the history on this machine and what made it so desireable. ... really don't know anymore about the machine other than its a Capcom game and ... if there is a website about it, I would love to have a link. ...
    (rec.games.pinball)