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.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]