UPDATE Statement in MS Access 2003
Posted on 2005-03-01
I have two tables, A and B on which I ran a left outer join query to get C. So C has some rows that did not match my selection criteria on ID. I need to insert a 0 into the ID column of C for all the rows that do not have an ID number.
How can I do this in Access 2003?