I have

INSERT tbl2

SELECT id,fname,lname from tbl1

WHERE ref# = '123'

This works fine but what if I just wanted to insert fname and leave lname out (which would insert NULLS in that column).