Fill in blanks from another table

[HectorH]

How do you replace blank fields in one table with entries from another table. I have been using fields from table A and repacing with table B

Selct a.name, iif (a.location<> "",a.location,b.location) from


table a, table b
where b.location = (Select b.location from table b, table a where a.name = b.name)

I am not returing any rows

Thanks in advance!

[pbaldy]

Try this shot in the dark:

Select a.name, iif (a.location<> "",a.location,b.location)
from table a INNER JOIN table b ON a.name = b.name

adding the actual table names of course. If the field is Null, I'd use the Nz() function instead of the IIf().