Update with a Join?
Posted on 2011-03-03
I have 2 tables. Lets call them audit and docs.
audit contains a list of docid's with a time/date stamp
docs contains the same list of docid's and also contains a flag field.
I want to update docs.flag to 0 where audit.timestamp is equal to a date.
Both tables contain docid.
I assume this is a join, I'm just not sure how to do it, can anybody assist please?