INSERT INTO tbl2 (fname) SELECT fname FROM tbl1 WHERE ref#='123'

Btw, the # sign isn't really good to be used as a column name. I have seen several threads here, where this caused more or less severe problems.