Re: fill blanks in one table using another

[laptop alias]

;-)

'round here we normally write that kind of thing this way:

SELECT A1.fieldA
     , A2.field1
     , A2.field2 
  FROM table1 A2
  JOIN table2 A1 
    ON A1.key = A2.fieldA;