>I need to update the InvoiceId column in Results.dbf from the InvoiceId column
>in Commits.dbf. I know I could use a join on DtId, which exists in both tables,
>but i'm not sure of the syntax.
>
>Anyone?
UPDATE Results SET InvoiceId = Commits.InvoiceId WHERE Results.DtId = Commit.DtId
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.